Postgresql - system catalogs

环境 ：pg 11.1

 

系统表：

pg_aggregate	aggregate functions.
pg_am	relation access methods(btree, hash, gist, gin, spgist, brin)
pg_amop	operators associated with access method operator families.
pg_amproc	support functions associated with access method operator families. There is one row for each support function belonging to an operator family.
pg_attrdef	column default values
pg_attribute	table columns
pg_authid	database authorization identifiers (roles)
pg_auth_members	the membership relations between roles
pg_cast	data type conversion paths, both built-in and user-defined.
pg_class	tables and most everything else that has columns or is otherwise similar to a table.  includes indexes, sequences, views, materialized views, composite types, and TOAST tables.
pg_collation	describes the available collations, which are essentially mappings from an SQL name to operating system locale categories.
pg_constraint	check, primary key, unique, foreign key, and exclusion constraints on tables.
pg_conversion	encoding conversion functions
pg_database	information about the available databases
pg_db_role_setting	default values that have been set for run-time configuration variables, for each role and database combination.
pg_default_acl	the initial privileges to be assigned to an object belonging to the indicated user.
pg_depend	dependency relationships between database objects
pg_description	optional descriptions (comments) for each database object.
pg_enum	the values and labels for each enum type
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	contains auxiliary information about foreign tables.
pg_index	indexes
pg_inherits	inheritance hierarchies. There is one entry for each direct parent-child table relationship in the database.
pg_init_privs	initial privileges of objects in the system
pg_language	registers languages in which you can write functions or stored procedures(c, sql, plpgsql)
pg_largeobject	holds the data making up “large objects”. A large object is identified by an OID assigned when it is created.Each large object is broken into segments or “pages” small enough to be conveniently stored as rows in pg_largeobject.
pg_largeobject_metadata	holds metadata associated with large objects. The actual large object data is stored in pg_largeobject.
pg_namespace	A namespace is the structure underlying SQL schemas: each namespace can have a separate collection of relations, types, etc. without name conflicts.
pg_opclass	index access method operator classes. Each operator class defines semantics for index columns of a particular data type and a particular index access method.
pg_operator	operators
pg_opfamily	operator families. Each operator family is a collection of operators and associated support routines that implement the semantics specified for a particular index access method
pg_partitioned_table	how tables are partitioned
pg_pltemplate	“template” information for procedural languages.
pg_policy	row level security policies for tables.
pg_proc	functions, procedures, aggregate functions, and window functions (
pg_publication	all publications created in the database
pg_publication_rel	the mapping between relations and publications in the database
pg_range	range types
pg_replication_origin	all replication origins created
pg_rewrite	rewrite rules for tables and views.
pg_seclabel	security labels on database objects.
pg_sequence	sequences
pg_shdepend	dependency relationships between database objects and shared objects, such as roles.
pg_shdescription	optional descriptions (comments) for shared database objects.
pg_shseclabel	security labels on shared database objects.
pg_statistic	statistical data about the contents of the database. Entries are created by ANALYZE and subsequently used by the query planner. Note that all the statistical data is inherently approximate, even assuming that it is up-to-date.
pg_statistic_ext	extended planner statistics
pg_subscription	all existing logical replication subscriptions
pg_subscription_rel	the state for each replicated relation in each subscription.
pg_tablespace	available tablespaces.
pg_transform	transforms, which are a mechanism to adapt data types to procedural languages.
pg_trigger	triggers on tables and views.
pg_ts_config	representing text search configurations.
pg_ts_config_map	showing which text search dictionaries should be consulted, and in what order, for each output token type of each text search configuration's parser.
pg_ts_dict	entries defining text search dictionaries.
pg_ts_parser	entries defining text search parsers
pg_ts_template	entries defining text search templates.
pg_type	data types.
pg_user_mapping	the mappings from local user to remote.

 

 

系统视图

pg_available_extensions	available extensions
pg_available_extensionversions	available versions of extensions
pg_config	compile-time configuration parameters
pg_cursors	open cursors
pg_file_settings	summary of configuration file contents
pg_group	groups of database users
pg_hba_file_rules	summary of client authentication configuration file contents
pg_indexes	indexes
pg_locks	locks currently held or awaited
pg_matviews	materialized views
pg_policies	policies
pg_prepared_statements	prepared statements
pg_prepared_xacts	prepared transactions
pg_publication_tables	publications and their associated tables
pg_replication_origin_status	information about replication origins, including replication progress
pg_replication_slots	replication slot information
pg_roles	database roles
pg_rules	rules
pg_seclabels	security labels
pg_sequences	sequences
pg_settings	parameter settings
pg_shadow	database users
pg_stats	planner statistics
pg_tables	tables
pg_timezone_abbrevs	time zone abbreviations
pg_timezone_name	time zone names
pg_user	database users
pg_user_mappings	user mappings
pg_views	views