pg_rewrite

A system table containing rewrite rules for tables and views

pg_rewrite is a system catalogue table containing rewrite rules for tables and views

pg_rewrite has been present in all PostgreSQL versions.

Definition by PostgreSQL version

pg_rewrite (PostgreSQL 14)

               Table "pg_catalog.pg_rewrite"
   Column   |     Type     | Collation | Nullable | Default 
------------+--------------+-----------+----------+---------
 oid        | oid          |           | not null | 
 rulename   | name         |           | not null | 
 ev_class   | oid          |           | not null | 
 ev_type    | "char"       |           | not null | 
 ev_enabled | "char"       |           | not null | 
 is_instead | boolean      |           | not null | 
 ev_qual    | pg_node_tree | C         | not null | 
 ev_action  | pg_node_tree | C         | not null | 
Indexes:
    "pg_rewrite_oid_index" PRIMARY KEY, btree (oid)
    "pg_rewrite_rel_rulename_index" UNIQUE CONSTRAINT, btree (ev_class, rulename)

Documentation: pg_rewrite

pg_rewrite (PostgreSQL 13)

               Table "pg_catalog.pg_rewrite"
   Column   |     Type     | Collation | Nullable | Default 
------------+--------------+-----------+----------+---------
 oid        | oid          |           | not null | 
 rulename   | name         |           | not null | 
 ev_class   | oid          |           | not null | 
 ev_type    | "char"       |           | not null | 
 ev_enabled | "char"       |           | not null | 
 is_instead | boolean      |           | not null | 
 ev_qual    | pg_node_tree | C         | not null | 
 ev_action  | pg_node_tree | C         | not null | 
Indexes:
    "pg_rewrite_oid_index" UNIQUE, btree (oid)
    "pg_rewrite_rel_rulename_index" UNIQUE, btree (ev_class, rulename)

Documentation: pg_rewrite

pg_rewrite (PostgreSQL 12)

               Table "pg_catalog.pg_rewrite"
   Column   |     Type     | Collation | Nullable | Default 
------------+--------------+-----------+----------+---------
 oid        | oid          |           | not null | 
 rulename   | name         |           | not null | 
 ev_class   | oid          |           | not null | 
 ev_type    | "char"       |           | not null | 
 ev_enabled | "char"       |           | not null | 
 is_instead | boolean      |           | not null | 
 ev_qual    | pg_node_tree | C         | not null | 
 ev_action  | pg_node_tree | C         | not null | 
Indexes:
    "pg_rewrite_oid_index" UNIQUE, btree (oid)
    "pg_rewrite_rel_rulename_index" UNIQUE, btree (ev_class, rulename)

Documentation: pg_rewrite

pg_rewrite (PostgreSQL 11)

               Table "pg_catalog.pg_rewrite"
   Column   |     Type     | Collation | Nullable | Default 
------------+--------------+-----------+----------+---------
 rulename   | name         |           | not null | 
 ev_class   | oid          |           | not null | 
 ev_type    | "char"       |           | not null | 
 ev_enabled | "char"       |           | not null | 
 is_instead | boolean      |           | not null | 
 ev_qual    | pg_node_tree |           |          | 
 ev_action  | pg_node_tree |           |          | 
Indexes:
    "pg_rewrite_oid_index" UNIQUE, btree (oid)
    "pg_rewrite_rel_rulename_index" UNIQUE, btree (ev_class, rulename)

Documentation: pg_rewrite

pg_rewrite (PostgreSQL 10)

               Table "pg_catalog.pg_rewrite"
   Column   |     Type     | Collation | Nullable | Default 
------------+--------------+-----------+----------+---------
 rulename   | name         |           | not null | 
 ev_class   | oid          |           | not null | 
 ev_type    | "char"       |           | not null | 
 ev_enabled | "char"       |           | not null | 
 is_instead | boolean      |           | not null | 
 ev_qual    | pg_node_tree |           |          | 
 ev_action  | pg_node_tree |           |          | 
Indexes:
    "pg_rewrite_oid_index" UNIQUE, btree (oid)
    "pg_rewrite_rel_rulename_index" UNIQUE, btree (ev_class, rulename)

Documentation: pg_rewrite

pg_rewrite (PostgreSQL 9.6)

     Table "pg_catalog.pg_rewrite"
   Column   |     Type     | Modifiers 
------------+--------------+-----------
 rulename   | name         | not null
 ev_class   | oid          | not null
 ev_type    | "char"       | not null
 ev_enabled | "char"       | not null
 is_instead | boolean      | not null
 ev_qual    | pg_node_tree | 
 ev_action  | pg_node_tree | 
Indexes:
    "pg_rewrite_oid_index" UNIQUE, btree (oid)
    "pg_rewrite_rel_rulename_index" UNIQUE, btree (ev_class, rulename)

Documentation: pg_rewrite

pg_rewrite (PostgreSQL 9.5)

     Table "pg_catalog.pg_rewrite"
   Column   |     Type     | Modifiers 
------------+--------------+-----------
 rulename   | name         | not null
 ev_class   | oid          | not null
 ev_type    | "char"       | not null
 ev_enabled | "char"       | not null
 is_instead | boolean      | not null
 ev_qual    | pg_node_tree | 
 ev_action  | pg_node_tree | 
Indexes:
    "pg_rewrite_oid_index" UNIQUE, btree (oid)
    "pg_rewrite_rel_rulename_index" UNIQUE, btree (ev_class, rulename)

Documentation: pg_rewrite

pg_rewrite (PostgreSQL 9.4)

     Table "pg_catalog.pg_rewrite"
   Column   |     Type     | Modifiers 
------------+--------------+-----------
 rulename   | name         | not null
 ev_class   | oid          | not null
 ev_type    | "char"       | not null
 ev_enabled | "char"       | not null
 is_instead | boolean      | not null
 ev_qual    | pg_node_tree | 
 ev_action  | pg_node_tree | 
Indexes:
    "pg_rewrite_oid_index" UNIQUE, btree (oid)
    "pg_rewrite_rel_rulename_index" UNIQUE, btree (ev_class, rulename)

Documentation: pg_rewrite

pg_rewrite (PostgreSQL 9.3)

     Table "pg_catalog.pg_rewrite"
   Column   |     Type     | Modifiers 
------------+--------------+-----------
 rulename   | name         | not null
 ev_class   | oid          | not null
 ev_attr    | smallint     | not null
 ev_type    | "char"       | not null
 ev_enabled | "char"       | not null
 is_instead | boolean      | not null
 ev_qual    | pg_node_tree | 
 ev_action  | pg_node_tree | 
Indexes:
    "pg_rewrite_oid_index" UNIQUE, btree (oid)
    "pg_rewrite_rel_rulename_index" UNIQUE, btree (ev_class, rulename)

Documentation: pg_rewrite

pg_rewrite (PostgreSQL 9.2)

     Table "pg_catalog.pg_rewrite"
   Column   |     Type     | Modifiers 
------------+--------------+-----------
 rulename   | name         | not null
 ev_class   | oid          | not null
 ev_attr    | smallint     | not null
 ev_type    | "char"       | not null
 ev_enabled | "char"       | not null
 is_instead | boolean      | not null
 ev_qual    | pg_node_tree | 
 ev_action  | pg_node_tree | 
Indexes:
    "pg_rewrite_oid_index" UNIQUE, btree (oid)
    "pg_rewrite_rel_rulename_index" UNIQUE, btree (ev_class, rulename)

Documentation: pg_rewrite

pg_rewrite (PostgreSQL 9.1)

     Table "pg_catalog.pg_rewrite"
   Column   |     Type     | Modifiers 
------------+--------------+-----------
 rulename   | name         | not null
 ev_class   | oid          | not null
 ev_attr    | smallint     | not null
 ev_type    | "char"       | not null
 ev_enabled | "char"       | not null
 is_instead | boolean      | not null
 ev_qual    | pg_node_tree | 
 ev_action  | pg_node_tree | 
Indexes:
    "pg_rewrite_oid_index" UNIQUE, btree (oid)
    "pg_rewrite_rel_rulename_index" UNIQUE, btree (ev_class, rulename)

Documentation: pg_rewrite

pg_rewrite (PostgreSQL 9.0)

   Table "pg_catalog.pg_rewrite"
   Column   |   Type   | Modifiers 
------------+----------+-----------
 rulename   | name     | not null
 ev_class   | oid      | not null
 ev_attr    | smallint | not null
 ev_type    | "char"   | not null
 ev_enabled | "char"   | not null
 is_instead | boolean  | not null
 ev_qual    | text     | 
 ev_action  | text     | 
Indexes:
    "pg_rewrite_oid_index" UNIQUE, btree (oid)
    "pg_rewrite_rel_rulename_index" UNIQUE, btree (ev_class, rulename)

Documentation: pg_rewrite

pg_rewrite (PostgreSQL 8.4)

   Table "pg_catalog.pg_rewrite"
   Column   |   Type   | Modifiers 
------------+----------+-----------
 rulename   | name     | not null
 ev_class   | oid      | not null
 ev_attr    | smallint | not null
 ev_type    | "char"   | not null
 ev_enabled | "char"   | not null
 is_instead | boolean  | not null
 ev_qual    | text     | 
 ev_action  | text     | 
Indexes:
    "pg_rewrite_oid_index" UNIQUE, btree (oid)
    "pg_rewrite_rel_rulename_index" UNIQUE, btree (ev_class, rulename)

Documentation: pg_rewrite

pg_rewrite (PostgreSQL 8.3)

   Table "pg_catalog.pg_rewrite"
   Column   |   Type   | Modifiers 
------------+----------+-----------
 rulename   | name     | not null
 ev_class   | oid      | not null
 ev_attr    | smallint | not null
 ev_type    | "char"   | not null
 ev_enabled | "char"   | not null
 is_instead | boolean  | not null
 ev_qual    | text     | 
 ev_action  | text     | 
Indexes:
    "pg_rewrite_oid_index" UNIQUE, btree (oid)
    "pg_rewrite_rel_rulename_index" UNIQUE, btree (ev_class, rulename)

Documentation: pg_rewrite

pg_rewrite (PostgreSQL 8.2)

   Table "pg_catalog.pg_rewrite"
   Column   |   Type   | Modifiers 
------------+----------+-----------
 rulename   | name     | not null
 ev_class   | oid      | not null
 ev_attr    | smallint | not null
 ev_type    | "char"   | not null
 is_instead | boolean  | not null
 ev_qual    | text     | 
 ev_action  | text     | 
Indexes:
    "pg_rewrite_oid_index" UNIQUE, btree (oid)
    "pg_rewrite_rel_rulename_index" UNIQUE, btree (ev_class, rulename)

Documentation: pg_rewrite

Change history

Note: list does not contain any changes made before PostgreSQL 8.2.

PostgreSQL 9.1
- column ev_qual changed to type pg_node_tree
- column ev_action changed to type pg_node_tree
PostgreSQL 8.3
- column ev_enabled added (commit )

References

PostgreSQL documentation: pg_rewrite

Version charts

Useful overviews

Useful links

Contents

pg_rewrite

Definition by PostgreSQL version

pg_rewrite (PostgreSQL 14)

pg_rewrite (PostgreSQL 13)

pg_rewrite (PostgreSQL 12)

pg_rewrite (PostgreSQL 11)

pg_rewrite (PostgreSQL 10)

pg_rewrite (PostgreSQL 9.6)

pg_rewrite (PostgreSQL 9.5)

pg_rewrite (PostgreSQL 9.4)

pg_rewrite (PostgreSQL 9.3)

pg_rewrite (PostgreSQL 9.2)

pg_rewrite (PostgreSQL 9.1)

pg_rewrite (PostgreSQL 9.0)

pg_rewrite (PostgreSQL 8.4)

pg_rewrite (PostgreSQL 8.3)

pg_rewrite (PostgreSQL 8.2)

Change history

References

Categories