System information functions
RisingWave provides functions to help you get system information, including database, schema, user, role, session, and more.
current_database()
Returns the name of the current database. You can use this function in SQL commands, functions, and operators.
current_database() → *current_database_name*
SELECT current_database(); → `db_name`
SELECT count(current_database()); → 1
current_role
Returns the name of the role that the current user is acting as, if the current user is a member of one or more roles.
current_role → *current_role_name*
current_role() → *current_role_name*
SELECT current_role(); → 'root'
current_schema
Returns the current schema. This is the schema that will be used for creating tables or other named objects without specifying a target schema.
current_schema → *current_schema_name*
current_schema() → *current_schema_name*
SELECT current_schema(); → 'public'
current_user
Returns the name of the current effective user.
current_user → *user_name*
current_user() → *user_name*
SELECT current_user(); → `root`
pg_typeof()
Returns the standard name of the data type of the provided value. More specifically, it returns the OID of the data type of the provided value. It returns a regtype, which is an OID alias type. Therefore it’s the same as an OID for comparison purposes but displays as a type name.
pg_typeof() → regtype
SELECT pg_typeof(round(null)); → `double precision`
SELECT pg_typeof(row(true, 1, 'hello')); → `record`
SELECT pg_typeof(array[1, 2]); → `integer[]`
pg_relation_size
Computes the disk space used by one “fork” of the specified relation.
pg_relation_size ( relation regclass [, 'main' ] ) → bigint
Returns the size of the main data fork of the relation. This function can be used to determine if the main data fork of a relation exists. If its size is not 0, it means that the main data fork of the relation exists.
SELECT pg_relation_size('t') != 0; → t
SELECT pg_relation_size('t', 'main') != 0; → t
session_user
Returns the name of the current session user.
session_user → *session_user_name*
session_user() → *session_user_name*
SELECT session_user(); → `root`
user
Returns the name of the current database user.
user → *user_name*
user() → *user_name*
SELECT user(); → `root`
version()
Displays the PostgreSQL version and the RisingWave version implemented in the current instance of RisingWave.
SELECT version ();
---------RESULT
version
-----------------
PostgreSQL 8.3-RisingWave-1.0.0-alpha (76672d87cf5c20aa8fbb6f11996ef15255443b51)
(1 row)