GaussDB-常量与宏
GaussDB支持的常量和宏请参见表1。
| 参数 | 描述 | 示例 | |
|---|---|---|---|
| CURRENT_CATALOG | 当前数据库 | ``` | |
| testdb=# SELECT CURRENT_CATALOG; current_database ------------------ testdb (1 row) |
| -------------------------------------------------------------------------------------------- | |
| CURRENT_ROLE | 当前用户 | | ```
gaussdb=# SELECT CURRENT_ROLE; current_user -------------- omm (1 row)
``` |
| ------------------------------------------------------------------------------- | |
| CURRENT_SCHEMA | 当前数据库模式 | | ```
gaussdb=# SELECT CURRENT_SCHEMA; current_schema ---------------- public (1 row)
``` |
| ---------------------------------------------------------------------------------------- | |
| CURRENT_USER | 当前用户 | | ```
gaussdb=# SELECT CURRENT_USER; current_user -------------- omm (1 row)
``` |
| ------------------------------------------------------------------------------- | |
| LOCALTIMESTAMP | 当前会话时间（无时区） | | ```
gaussdb=# SELECT LOCALTIMESTAMP; timestamp ---------------------------- 2015-10-10 15:37:30.968538 (1 row)
``` |
| ---------------------------------------------------------------------------------------------------------------------------- | |
| NULL | 空值 | - |
| SESSION_USER | 当前系统用户 | | ```
gaussdb=# SELECT SESSION_USER; session_user -------------- omm (1 row)
``` |
| ------------------------------------------------------------------------------- | |
| SYSDATE | 当前系统日期 | | ```
gaussdb=# SELECT SYSDATE; sysdate --------------------- 2015-10-10 15:48:53 (1 row)
``` |
| -------------------------------------------------------------------------------------------- | |
| USER | 当前用户，此用户为CURRENT_USER的别名。 | | ```
gaussdb=# SELECT USER; current_user -------------- omm (1 row)
``` |
| ----------------------------------------------------------------------- | |
更多详情请参考GaussDB 文档中心：<https://doc.hcs.huawei.com/db/zh-cn/gaussdbqlh/24.1.30/productdesc/qlh_03_0001.html>
