Postgresql 中文操作指南
Chapter 54. System Views
Table of Contents
除了系统目录外,PostgreSQL 还提供了一些内置视图。一些系统视图提供了对系统目录中一些常用查询的便捷访问。其他视图提供了对内部服务器状态的访问。
In addition to the system catalogs, PostgreSQL provides a number of built-in views. Some system views provide convenient access to some commonly used queries on the system catalogs. Other views provide access to internal server state.
信息架构 ( Chapter 37 ) 提供了一组替代视图,与系统视图的功能重叠。由于信息架构是 SQL 标准,而这里描述的视图是 PostgreSQL 特有的,因此如果您需要的所有信息,通常最好使用信息架构。
The information schema (Chapter 37) provides an alternative set of views which overlap the functionality of the system views. Since the information schema is SQL-standard whereas the views described here are PostgreSQL-specific, it’s usually better to use the information schema if it provides all the information you need.
Table 54.1 列出了此处描述的系统视图。下面是每个视图的更详细文档。还有一些其他视图提供了对累积统计信息的访问;它们在 Table 28.2 中进行了描述。
Table 54.1 lists the system views described here. More detailed documentation of each view follows below. There are some additional views that provide access to accumulated statistics; they are described in Table 28.2.