Postgresql 中文操作指南
54.1. Overview #
Table 54.1列出了系统视图。以下是对每个目录的更详细说明。除非另有说明，此处描述的所有视图均为只读。
Table 54.1 lists the system views. More detailed documentation of each catalog follows below. Except where noted, all the views described here are read-only.
Table 54.1. System Views
View Name |
Purpose |
available extensions |
|
available versions of extensions |
|
backend memory contexts |
|
compile-time configuration parameters |
|
open cursors |
|
summary of configuration file contents |
|
groups of database users |
|
summary of client authentication configuration file contents |
|
summary of client user name mapping configuration file contents |
|
indexes |
|
locks currently held or awaited |
|
materialized views |
|
policies |
|
prepared statements |
|
prepared transactions |
|
publications and information of their associated tables |
|
information about replication origins, including replication progress |
|
replication slot information |
|
database roles |
|
rules |
|
security labels |
|
sequences |
|
parameter settings |
|
database users |
|
shared memory allocations |
|
planner statistics |
|
extended planner statistics |
|
extended planner statistics for expressions |
|
tables |
|
time zone abbreviations |
|
time zone names |
|
database users |
|
user mappings |
|
views |