Postgresql 中文操作指南
54.1. Overview #
Table 54.1列出了系统视图。以下是对每个目录的更详细说明。除非另有说明，此处描述的所有视图均为只读。
Table 54.1. System Views
View Name |
Purpose |
available extensions |
|
available versions of extensions |
|
backend memory contexts |
|
compile-time configuration parameters |
|
open cursors |
|
配置文件内容摘要 |
|
groups of database users |
|
客户端认证配置文件内容摘要 |
|
客户端用户名映射配置文件内容摘要 |
|
indexes |
|
当前持有的或等待的锁定 |
|
materialized views |
|
policies |
|
prepared statements |
|
prepared transactions |
|
发布及其关联表的信息 |
|
复制原点信息，包括复制进度 |
|
replication slot information |
|
database roles |
|
rules |
|
security labels |
|
sequences |
|
parameter settings |
|
database users |
|
shared memory allocations |
|
planner statistics |
|
extended planner statistics |
|
表达式扩展计划人员统计 |
|
tables |
|
time zone abbreviations |
|
time zone names |
|
database users |
|
user mappings |
|
views |