RisingWave provides functions to help you get system information, including database, schema, user, role, session, and more.
current_database()
current_role
current_shema
current_user
pg_get_keywords()
word
, catcode
, and catdesc
.
The word
column contains the actual keyword, while the catcode
column indicates the category code of the keyword.
Here are the possible category codes and their meanings:
U
: Indicates an unreserved keyword.C
: Indicates a keyword that can be used as a column name.T
: Indicates a keyword that can be used as a type or function name.R
: Indicates a fully reserved keyword.catdesc
column contains a string that describes the category of the keyword. This description may be localized, depending on the language settings of the server.
pg_get_viewdef()
pg_index_column_has_property()
index
parameter represents the OID of the index, while the column
parameter represents the column number (starting from 1) within the index. If the property name is not recognized or doesn’t apply to the object, or if the OID or column number is invalid, this function will return NULL.
asc
: Indicates whether the column sorts in ascending order on a forward scan.desc
: Indicates whether the column sorts in descending order on a forward scan.nulls_first
: Indicates whether the column sorts with nulls first on a forward scan.nulls_last
: Indicates whether the column sorts with nulls last on a forward scan.pg_typeof()
pg_relation_size
session_user
user
version()