pg_views

• 16
• 15
• 14
• 13
• 12
• 11
• 10
• 9.6
• 9.5
• 9.4
• 9.3
• 9.2
• 9.1
• 9.0
• 8.4
• 8.3
• 8.2

             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 | 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";
    

Example record from pg_views:

postgres=# CREATE VIEW bar AS SELECT * FROM foo;
CREATE VIEW
 
postgres=# SELECT * FROM pg_views WHERE viewname = 'bar';
 schemaname | viewname | viewowner |   definition    
------------+----------+-----------+-----------------
 public     | bar      | postgres  |  SELECT foo.id,+
            |          |           |     foo.val    +
            |          |           |    FROM foo;
(1 row)

• PostgreSQL documentation: pg_views