Postgresql 中文操作指南
53.1. Overview #
Table 53.1 列出了系统目录。下面将更详细地说明每个目录。
大多数系统目录在创建数据库时从模板数据库中复制，此后特定于数据库。少数目录在集群中的所有数据库中物理共享；这些在各目录的描述中注明。
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) |
|
表、索引、序列、视图（“关系”） |
|
collations (locale information) |
|
检查约束、唯一约束、主键约束、外键约束 |
|
encoding conversion information |
|
这个数据库集群中的数据库 |
|
per-role and per-database settings |
|
对象类型的默认特权 |
|
dependencies between database objects |
|
对数据库对象进行的描述或评论 |
|
enum 标签和值定义 |
|
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 |
|
大对象的数据页 |
|
metadata for large objects |
|
schemas |
|
access method operator classes |
|
operators |
|
access method operator families |
|
已授予特权的配置参数 |
|
表的 partition key 的信息 |
|
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 |
|
数据库对象上的安全标签 |
|
information about sequences |
|
dependencies on shared objects |
|
comments on shared objects |
|
共享数据库对象上的安全标签 |
|
planner statistics |
|
extended planner statistics (definition) |
|
扩展规划器统计信息（已生成统计信息） |
|
logical replication subscriptions |
|
relation state for subscriptions |
|
此数据库集群内的表空间 |
|
转换（数据类型到过程语言转换） |
|
triggers |
|
text search configurations |
|
全文搜索配置的令牌映射 |
|
text search dictionaries |
|
text search parsers |
|
text search templates |
|
data types |
|
用户到外围服务器的映射 |