Postgresql 中文操作指南
53.1. Overview #
Table 53.1 列出了系统目录。下面将更详细地说明每个目录。
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 |
aggregate functions |
|
relation access methods |
|
access method operators |
|
access method support functions |
|
column default values |
|
table columns (“attributes”) |
|
authorization identifiers (roles) |
|
authorization identifier membership relationships |
|
casts (data type conversions) |
|
tables, indexes, sequences, views (“relations”) |
|
collations (locale information) |
|
check constraints, unique constraints, primary key constraints, foreign key constraints |
|
encoding conversion information |
|
databases within this database cluster |
|
per-role and per-database settings |
|
default privileges for object types |
|
dependencies between database objects |
|
descriptions or comments on database objects |
|
enum label and value definitions |
|
event triggers |
|
installed extensions |
|
foreign-data wrapper definitions |
|
foreign server definitions |
|
additional foreign table information |
|
additional index information |
|
table inheritance hierarchy |
|
object initial privileges |
|
languages for writing functions |
|
data pages for large objects |
|
metadata for large objects |
|
schemas |
|
access method operator classes |
|
operators |
|
access method operator families |
|
configuration parameters for which privileges have been granted |
|
information about partition key of tables |
|
row-security policies |
|
functions and procedures |
|
publications for logical replication |
|
schema to publication mapping |
|
relation to publication mapping |
|
information about range types |
|
registered replication origins |
|
query rewrite rules |
|
security labels on database objects |
|
information about sequences |
|
dependencies on shared objects |
|
comments on shared objects |
|
security labels on shared database objects |
|
planner statistics |
|
extended planner statistics (definition) |
|
extended planner statistics (built statistics) |
|
logical replication subscriptions |
|
relation state for subscriptions |
|
tablespaces within this database cluster |
|
transforms (data type to procedural language conversions) |
|
triggers |
|
text search configurations |
|
text search configurations' token mappings |
|
text search dictionaries |
|
text search parsers |
|
text search templates |
|
data types |
|
mappings of users to foreign servers |