PostgreSQL catalogs and functions

RisingWave supports these system catalogs, views, and functions of PostgreSQL.

note

RisingWave does not fully support all PostgreSQL system catalog columns.

Catalogs and views

Catalog/View Name	Description
pg_am	Contains information about relation access methods.
pg_attrdef	Contains default values for table columns.
pg_attribute	Contains information about table columns.
pg_cast	Contains information about type casts.
pg_conversion	Contains information about encoding conversion functions.
pg_class	Contains information about tables, indexes, sequences, and views.
pg_collation	Contains information about collations.
pg_database	Contains information about the available databases.
pg_description	Contains descriptive information about database objects.
pg_enum	Contains entries showing the values and labels for each enum type.
pg_index	Contains part of the information about indexes. The rest is mostly in pg_class.
pg_indexes	Contains information about each index in the database.
pg_matviews	Contains information about about each materialized view in the database.
pg_namespace	Contains information about namespaces.
pg_opclass	Contains information about index access method operator classes.
pg_operator	Contains information about operators.
pg_proc	Contains information about functions, aggregate functions, and window functions.
pg_roles	Contains information about database roles.
pg_settings	Contains information about run-time parameters of the server.
pg_shdescription	Contains descriptive information about shared database objects.
pg_stat_activity	Contains information about the current activity of server processes.
pg_tablespace	Contains information about the available tablespaces.
pg_type	Contains information about data types.
pg_user	Contains information about database users.
pg_views	Contains information about each view in the database.

Functions

Function	Description
pg_cancel_backend()	Cancels a backend's current query. You can execute this against another backend that has exactly the same role as the user calling the function. In all other cases, you must be a superuser. For more details, see System Administration Functions.
pg_terminate_backend()	Terminates a backend. You can execute this against another backend that has exactly the same role as the user calling the function. In all other cases, you must be a superuser. For more details, see System Administration Functions.
pg_backend_pid()	Returns the ID of the server process attached to the current session. For more details, see System Information Functions and Operators.
version()	Displays the PostgreSQL version and the RisingWave version implemented in the current instance of RisingWave. Output example: PostgreSQL 13.9-RW-0.2.0-alpha.