This page lists both RisingWave system administration functions and PostgreSQL system administration functions that are supported in RisingWave.
current_setting()
SHOW
.
SHOW ALL
command to get the complete list of runtime parameters and corresponding descriptions.
has_table_privilege()
public
to refer to the PUBLIC pseudo-role. If no argument is provided, it assumes the current user.
To specify the table, you can use its name or OID. If needed, you can schema-qualify the table name.
The desired access privilege type is specified as a text string. It must be one of the following values: SELECT
, INSERT
, UPDATE
, DELETE
, TRUNCATE
, REFERENCES
, or TRIGGER
. You can also add WITH GRANT OPTION
to test if the privilege is held with the grant option. If you want to check for multiple privilege types, you can list them separated by commas. The result will be true if any of the listed privileges is held. The case of the privilege string is not important, and you can have extra whitespace between privilege names, but not within them.
has_schema_privilege()
has_table_privilege
function.
The desired access privilege type should be a combination of CREATE
and/or USAGE
, such as “CREATE, USAGE”, or just a single privilege type like “CREATE” or “USAGE”.
has_any_column_privilege()
has_table_privilege
function.
has_function_privilege()
rw_recovery_status()
STARTING
, RECOVERING
, or RUNNING
.
pg_is_in_recovery()
set_config()
setting_name
to new_value
, and returns that value. If is_local
is true
, the new value will only apply during the current transaction. If you want the new value to apply for the rest of the current session, use false
instead. This function corresponds to the SQL command SET.
pg_indexes_size('table_name')
pg_table_size('table_name')
pg_stat_get_numscans('table_name')