On this page

Show all

Help Center/ GaussDB(DWS)/ SQL Syntax Reference (8.1.3.x)/ Constant and Macro

Constant and Macro

Updated on 2024-12-19 GMT+08:00

View PDF

Table 1 lists the constants and macros that can be used in GaussDB(DWS).

Table 1 Constants and macros

Parameter

Description

Example SQL Statements

CURRENT_CATALOG

Specifies the current database.

        
           SELECT CURRENT_CATALOG;

CURRENT_ROLE

Current role

        
           SELECT CURRENT_ROLE;

CURRENT_SCHEMA

Current database model

        
           SELECT CURRENT_SCHEMA;

CURRENT_USER

Current user

        
           SELECT CURRENT_USER;

LOCALTIMESTAMP

Current session time (without time zone)

        
           SELECT LOCALTIMESTAMP;

NULL

This parameter is left blank.

SESSION_USER

Current system user

        
           SELECT SESSION_USER;

SYSDATE

Current system date

        
           SELECT SYSDATE;

SELECT now()::DATE;

USER

Current user, which is the same as the value of CURRENT_USER.

        
           SELECT USER;

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel