CURRENT_USER

Returns a VARCHAR containing the name of the user who initiated the current database connection.

Behavior type

Syntax

CURRENT_USER()

Notes

• The CURRENT_USER function does not require parentheses.

• This function is useful for permission checking.

• CURRENT_USER is equivalent to SESSION_USER, USER, and USERNAME.

Examples

=> SELECT CURRENT_USER();
 CURRENT_USER
--------------
 dbadmin
(1 row)

The following command returns the same results without the parentheses:

=> SELECT CURRENT_USER;
 CURRENT_USER
--------------
 dbadmin
(1 row)