The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Who am I?

edited May 2018 in Tips from the Team

Jim Knicely authored this tip.

There are several ways to figure out who the session user is. This comes in handy for logging.

Example:

[[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)

Have fun!

Sign In or Register to comment.

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.