↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

System Catalogs / System views

The view pg_views provides access to useful information about each view in the database.

Reading PG 18current·documented in 24 of 24 versions, 7.4 to 20

Kind
System views
Columns in this snapshot
4
Definition source
English manual
Metadata snapshot
18.6

Columns 4

As listed in the PostgreSQL 18 manual.

ColumnTypeDescription / reference
schemanamenameName of schema containing view
pg_namespace.nspname
viewnamenameName of view
pg_class.relname
viewownernameName of view's owner
pg_authid.rolname
definitiontextView definition (a reconstructed SELECT query)
Column history across versions
Version history 1
  1. 8.1 → 8.2 reworded

Definition snapshot: english-manuals:34b0398dc65e98b6e4c6650ed0f… · English manual source