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_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_partitioned_tableContains information about how tables are partitioned.
pg_procContains information about functions, aggregate functions, and window functions.
pg_rangeContains information about range types in the database.
pg_rolesContains information about database roles.
pg_sequencesContains information about each sequence in the database.
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.