• Browse categories
• PostgreSQL releases
  • PostgreSQL 14 (dev)
  • PostgreSQL 13 (latest)
  • PostgreSQL 12
  • PostgreSQL 11
  • PostgreSQL 10
  • PostgreSQL 9.6
  • PostgreSQL 9.5
  • PostgreSQL 9.4 (EOL)

Useful articles

Useful links

pg_views

pg_views is system catalogue view listing the available views in the current database.

pg_views was added in PostgreSQL 6.4 (initial commit 15cb32d9).

Definition by PostgreSQL version

             View "pg_catalog.pg_views"
   Column   | Type | Collation | Nullable | Default
------------+------+-----------+----------+---------
 schemaname | name |           |          |
 viewname   | name |           |          |
 viewowner  | name |           |          |
 definition | text |           |          |
    

             View "pg_catalog.pg_views"
   Column   | Type | Collation | Nullable | Default
------------+------+-----------+----------+---------
 schemaname | name |           |          |
 viewname   | name |           |          |
 viewowner  | name |           |          |
 definition | text |           |          |
    

             View "pg_catalog.pg_views"
   Column   | Type | Collation | Nullable | Default
------------+------+-----------+----------+---------
 schemaname | name |           |          |
 viewname   | name |           |          |
 viewowner  | name |           |          |
 definition | text |           |          |
    

             View "pg_catalog.pg_views"
   Column   | Type | Collation | Nullable | Default
------------+------+-----------+----------+---------
 schemaname | name |           |          |
 viewname   | name |           |          |
 viewowner  | name |           |          |
 definition | text |           |          |
    

  View "pg_catalog.pg_views"
   Column   | Type | Modifiers
------------+------+-----------
 schemaname | name |
 viewname   | name |
 viewowner  | name |
 definition | text |
    

  View "pg_catalog.pg_views"
   Column   | Type | Modifiers
------------+------+-----------
 schemaname | name |
 viewname   | name |
 viewowner  | name |
 definition | text |
    

  View "pg_catalog.pg_views"
   Column   | Type | Modifiers
------------+------+-----------
 schemaname | name |
 viewname   | name |
 viewowner  | name |
 definition | text |
    

  View "pg_catalog.pg_views"
   Column   | Type | Modifiers
------------+------+-----------
 schemaname | name |
 viewname   | name |
 viewowner  | name |
 definition | text |
    

  View "pg_catalog.pg_views"
   Column   | Type | Modifiers
------------+------+-----------
 schemaname | name |
 viewname   | name |
 viewowner  | name |
 definition | text |
    

  View "pg_catalog.pg_views"
   Column   | Type | Modifiers
------------+------+-----------
 schemaname | name |
 viewname   | name |
 viewowner  | name |
 definition | text |
    

  View "pg_catalog.pg_views"
   Column   | Type | Modifiers
------------+------+-----------
 schemaname | name |
 viewname   | name |
 viewowner  | name |
 definition | text |
    

  View "pg_catalog.pg_views"
   Column   | Type | Modifiers
------------+------+-----------
 schemaname | name |
 viewname   | name |
 viewowner  | name |
 definition | text |
View definition:
 SELECT n.nspname AS schemaname, c.relname AS viewname, pg_get_userbyid(c.relowner) AS viewowner, pg_get_viewdef(c.oid) AS definition
   FROM pg_class c
   LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
  WHERE c.relkind = 'v'::"char";
    

  View "pg_catalog.pg_views"
   Column   | Type | Modifiers
------------+------+-----------
 schemaname | name |
 viewname   | name |
 viewowner  | name |
 definition | text |
View definition:
 SELECT n.nspname AS schemaname, c.relname AS viewname, pg_get_userbyid(c.relowner) AS viewowner, pg_get_viewdef(c.oid) AS definition
   FROM pg_class c
   LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
  WHERE c.relkind = 'v'::"char";
    

  View "pg_catalog.pg_views"
   Column   | Type | Modifiers
------------+------+-----------
 schemaname | name |
 viewname   | name |
 viewowner  | name |
 definition | text |
View definition:
 SELECT n.nspname AS schemaname, c.relname AS viewname, pg_get_userbyid(c.relowner) AS viewowner, pg_get_viewdef(c.oid) AS definition
   FROM pg_class c
   LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
  WHERE c.relkind = 'v'::"char";
    

Change history

• PostgreSQL 7.3
  • column schemaname added (commit 3b78826b)
• PostgreSQL 6.4
  • added (commit 15cb32d9), initially as pg_view and renamed to to pg_views in commit a29ae226

References

Categories

See also