The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Who am I?
Jim Knicely authored this tip.
There are several ways to figure out who the session user is. This comes in handy for logging.
[[email protected] ~]$ vsql -U jim Welcome to vsql, the Vertica Analytic Database interactive terminal. Type: \h or \? for help with vsql commands \g or terminate with semicolon to execute query \q to quit jim=> select user; current_user -------------- jim (1 row) jim=> select current_user(); current_user -------------- jim (1 row)