Skip to main content

PostgreSQL catalogs

RisingWave supports these system catalogs and views of PostgreSQL.

For information about RisingWave and PostgreSQL system functions, see System administration functions and System information functions.

note

RisingWave does not fully support all PostgreSQL system catalog columns.

Catalog/View NameDescription
pg_amContains information about relation access methods.
pg_attrdefContains default values for table columns.
pg_attributeContains information about table columns.
pg_castContains information about type casts.
pg_constraintContains information about constraints defined for database tables. Constraints are used to enforce rules and restrictions on the data that can be stored in a table.
pg_inherits
pg_conversionContains information about encoding conversion functions.
pg_classContains information about tables, indexes, sequences, and views.
pg_collationContains information about collations.
pg_databaseContains information about the available databases.
pg_descriptionContains descriptive information about database objects.
pg_enumContains entries showing the values and labels for each enum type.
pg_indexContains part of the information about indexes. The rest is mostly in pg_class.
pg_indexesContains information about each index in the database.
pg_inheritsContains information about table inheritance relationships. In PostgreSQL, table inheritance is a feature that allows you to create a new table that inherits all the columns and constraints of an existing table.
pg_matviewsContains information about about each materialized view in the database.
pg_namespaceContains information about namespaces.
pg_opclassContains information about index access method operator classes.
pg_operatorContains information about operators.
pg_procContains information about functions, aggregate functions, and window functions.
pg_rolesContains information about database roles.
pg_settingsContains information about run-time parameters of the server.
pg_shadowContains information about database users. Specifically, it contains information about the login roles that have been created in the database, including their usernames, password hashes, and other authentication-related information.
pg_shdescriptionContains descriptive information about shared database objects.
pg_stat_activityContains information about the current activity of server processes.
pg_tablesContains information about the name, schema, and type of each table in the database. Example: SELECT tablename FROM pg_tables WHERE schemaname = 'public'; -> t1.
pg_tablespaceContains information about the available tablespaces.
pg_typeContains information about data types.
pg_userContains information about database users.
pg_viewsContains information about each view in the database.

Help us make this doc better!