53.1. Overview

53.1. Overview
Prev	Up	Chapter 53. System Catalogs	Home	Next

+ Table 53.1 lists the system catalogs. + More detailed documentation of each catalog follows below. +

+ Most system catalogs are copied from the template database during + database creation and are thereafter database-specific. A few + catalogs are physically shared across all databases in a cluster; + these are noted in the descriptions of the individual catalogs. +

Table 53.1. System Catalogs

Catalog Name	Purpose
`pg_aggregate`	aggregate functions
`pg_am`	relation access methods
`pg_amop`	access method operators
`pg_amproc`	access method support functions
`pg_attrdef`	column default values
`pg_attribute`	table columns (“attributes”)
`pg_authid`	authorization identifiers (roles)
`pg_auth_members`	authorization identifier membership relationships
`pg_cast`	casts (data type conversions)
`pg_class`	tables, indexes, sequences, views (“relations”)
`pg_collation`	collations (locale information)
`pg_constraint`	check constraints, unique constraints, primary key constraints, foreign key constraints
`pg_conversion`	encoding conversion information
`pg_database`	databases within this database cluster
`pg_db_role_setting`	per-role and per-database settings
`pg_default_acl`	default privileges for object types
`pg_depend`	dependencies between database objects
`pg_description`	descriptions or comments on database objects
`pg_enum`	enum label and value definitions
`pg_event_trigger`	event triggers
`pg_extension`	installed extensions
`pg_foreign_data_wrapper`	foreign-data wrapper definitions
`pg_foreign_server`	foreign server definitions
`pg_foreign_table`	additional foreign table information
`pg_index`	additional index information
`pg_inherits`	table inheritance hierarchy
`pg_init_privs`	object initial privileges
`pg_language`	languages for writing functions
`pg_largeobject`	data pages for large objects
`pg_largeobject_metadata`	metadata for large objects
`pg_namespace`	schemas
`pg_opclass`	access method operator classes
`pg_operator`	operators
`pg_opfamily`	access method operator families
`pg_parameter_acl`	configuration parameters for which privileges have been granted
`pg_partitioned_table`	information about partition key of tables
`pg_policy`	row-security policies
`pg_proc`	functions and procedures
`pg_publication`	publications for logical replication
`pg_publication_namespace`	schema to publication mapping
`pg_publication_rel`	relation to publication mapping
`pg_range`	information about range types
`pg_replication_origin`	registered replication origins
`pg_rewrite`	query rewrite rules
`pg_seclabel`	security labels on database objects
`pg_sequence`	information about sequences
`pg_shdepend`	dependencies on shared objects
`pg_shdescription`	comments on shared objects
`pg_shseclabel`	security labels on shared database objects
`pg_statistic`	planner statistics
`pg_statistic_ext`	extended planner statistics (definition)
`pg_statistic_ext_data`	extended planner statistics (built statistics)
`pg_subscription`	logical replication subscriptions
`pg_subscription_rel`	relation state for subscriptions
`pg_tablespace`	tablespaces within this database cluster
`pg_transform`	transforms (data type to procedural language conversions)
`pg_trigger`	triggers
`pg_ts_config`	text search configurations
`pg_ts_config_map`	text search configurations' token mappings
`pg_ts_dict`	text search dictionaries
`pg_ts_parser`	text search parsers
`pg_ts_template`	text search templates
`pg_type`	data types
`pg_user_mapping`	mappings of users to foreign servers