This page in other versions: 9.1 / 9.2 / 9.3 / 9.4 / current (9.5)  |  Development versions: devel  |  Unsupported versions: 7.4 / 8.0 / 8.1 / 8.2 / 8.3 / 8.4 / 9.0

43.30. System Views

In addition to the system catalogs, PostgreSQL provides a number of built-in views. The system views provide convenient access to some commonly used queries on the system catalogs. Some of these views provide access to internal server state, as well.

Table 43-30 lists the system views described here. More detailed documentation of each view follows below. There are some additional views that provide access to the results of the statistics collector; they are described in Table 23-1.

The information schema (Chapter 32) 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.

Except where noted, all the views described here are read-only.

Table 43-30. System Views

View Name Purpose
pg_indexes indexes
pg_locks currently held locks
pg_rules rules
pg_settings parameter settings
pg_stats planner statistics
pg_tables tables
pg_user database users
pg_views views
Privacy Policy | About PostgreSQL
Copyright © 1996-2016 The PostgreSQL Global Development Group