CURRENT_CATALOG
|
Specifies the current database.
|
openGauss=# SELECT CURRENT_CATALOG;
current_database
------------------
openGauss
(1 row)
|
CURRENT_ROLE
|
Specifies the current user.
|
openGauss=# SELECT CURRENT_ROLE;
current_user
--------------
omm
(1 row)
|
CURRENT_SCHEMA
|
Specifies the current database schema.
|
openGauss=# SELECT CURRENT_SCHEMA;
current_schema
----------------
public
(1 row)
|
CURRENT_USER
|
Specifies the current user.
|
openGauss=# SELECT CURRENT_USER;
current_user
--------------
omm
(1 row)
|
LOCALTIMESTAMP
|
Specifies the current session time (without time zone).
|
openGauss=# SELECT LOCALTIMESTAMP;
timestamp
----------------------------
2015-10-10 15:37:30.968538
(1 row)
|
NULL
|
This parameter is left blank.
|
N/A
|
SESSION_USER
|
Specifies the current system user.
|
openGauss=# SELECT SESSION_USER;
session_user
--------------
omm
(1 row)
|
SYSDATE
|
Specifies the current system date.
|
openGauss=# SELECT SYSDATE;
sysdate
---------------------
2015-10-10 15:48:53
(1 row)
|
USER
|
Specifies the current user, also called CURRENT_USER.
|
openGauss=# SELECT USER;
current_user
--------------
omm
(1 row)
|