System catalogs

The following table provides a list of PostgreSQL system catalogs.

Catalog name	Description
pg_aggregate	Provides information about aggregate functions.
pg_am	Provides information about relation access methods.
pg_amop	Provides information about operators associated with access method operator families.
pg_amproc	Provides information about support functions associated with access method operator families.
pg_attrdef	Provides information about column default expressions and generation expressions.
pg_attribute	Provides information about table columns.
pg_authid	Provides information about database authorization identifiers (roles).
pg_auth_members	Provides information about membership relations between roles.
pg_cast	Provides information about data type conversion paths.
pg_class	Provides information about tables and other objects that have columns.
pg_collation	Provides information about available collations.
pg_constraint	Provides information about table constraints (check, not-null, PK, unique, FK, exclusion).
pg_conversion	Provides information about encoding conversion functions.
pg_database	Provides information about databases.
pg_db_role_setting	Provides information about default configuration values per role–database pair.
pg_default_acl	Provides information about initial privileges for new objects.
pg_depend	Provides information about dependency relationships between objects.
pg_description	Provides information about optional object descriptions.
pg_enum	Provides information about values and labels for enum types.
pg_event_trigger	Provides information about event triggers.
pg_extension	Provides information about installed extensions.
pg_foreign_data_wrapper	Provides information about foreign-data wrapper definitions.
pg_foreign_server	Provides information about foreign server definitions.
pg_foreign_table	Provides information about foreign tables.
pg_index	Provides information about indexes.
pg_inherits	Provides information about table and index inheritance.
pg_init_privs	Provides information about initial privileges of system objects.
pg_language	Provides information about languages for functions and procedures.
pg_largeobject	Provides information about large object data.
pg_largeobject_metadata	Provides information about metadata for large objects.
pg_namespace	Provides information about namespaces (schemas).
pg_opclass	Provides information about operator classes.
pg_operator	Provides information about operator definitions.
pg_opfamily	Provides information about operator families.
pg_parameter_acl	Provides information about configuration parameters with privileges.
pg_partitioned_table	Provides information about partitioning metadata.
pg_policy	Provides information about row-level security policies.
pg_proc	Provides information about functions, procedures, aggregates, and window functions.
pg_publication	Provides information about logical replication publications.
pg_publication_namespace	Provides information about the mapping of schemas to publications.
pg_publication_rel	Provides information about the mapping of relations to publications.
pg_range	Provides information about range types.
pg_replication_origin	Provides information about replication origins.
pg_rewrite	Provides information about rewrite rules.
pg_seclabel	Provides information about security labels.
pg_sequence	Provides information about sequence metadata.
pg_shdepend	Provides information about dependencies involving shared objects.
pg_shdescription	Provides information about shared objects.
pg_shseclabel	Provides information about security labels for shared objects.
pg_statistic	Provides information about table statistics.
pg_statistic_ext	Provides information about extended statistics definitions.
pg_statistic_ext_data	Provides information about extended statistics data.
pg_subscription	Provides information about logical replication subscriptions.
pg_subscription_rel	Provides information about per-relation subscription state.
pg_tablespace	Provides information about tablespaces.
pg_transform	Provides information about data type transforms.
pg_trigger	Provides information about triggers.
pg_ts_config	Provides information about text search configurations.
pg_ts_config_map	Provides information about the mapping of token types to dictionaries within a text search configuration.
pg_ts_dict	Provides information about text search dictionaries.
pg_ts_parser	Provides information about text search parsers.
pg_ts_template	Provides information about text search templates.
pg_type	Provides information about data types.
pg_user_mapping	Provides information about user-specific connection mappings used to access foreign servers.