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.
| 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