• 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_policy

pg_policy is a system catalogue table storing row level security policies for tables.

pg_policy was added in PostgreSQL 9.5 (initial commit 491c029d).

Definition by PostgreSQL version

                 Table "pg_catalog.pg_policy"
    Column     |     Type     | Collation | Nullable | Default
---------------+--------------+-----------+----------+---------
 oid           | oid          |           | not null |
 polname       | name         |           | not null |
 polrelid      | oid          |           | not null |
 polcmd        | "char"       |           | not null |
 polpermissive | boolean      |           | not null |
 polroles      | oid[]        |           | not null |
 polqual       | pg_node_tree | C         |          |
 polwithcheck  | pg_node_tree | C         |          |
Indexes:
    "pg_policy_oid_index" UNIQUE, btree (oid)
    "pg_policy_polrelid_polname_index" UNIQUE, btree (polrelid, polname)
    

                 Table "pg_catalog.pg_policy"
    Column     |     Type     | Collation | Nullable | Default
---------------+--------------+-----------+----------+---------
 oid           | oid          |           | not null |
 polname       | name         |           | not null |
 polrelid      | oid          |           | not null |
 polcmd        | "char"       |           | not null |
 polpermissive | boolean      |           | not null |
 polroles      | oid[]        |           | not null |
 polqual       | pg_node_tree | C         |          |
 polwithcheck  | pg_node_tree | C         |          |
Indexes:
    "pg_policy_oid_index" UNIQUE, btree (oid)
    "pg_policy_polrelid_polname_index" UNIQUE, btree (polrelid, polname)
    

                 Table "pg_catalog.pg_policy"
    Column     |     Type     | Collation | Nullable | Default
---------------+--------------+-----------+----------+---------
 polname       | name         |           | not null |
 polrelid      | oid          |           | not null |
 polcmd        | "char"       |           | not null |
 polpermissive | boolean      |           | not null |
 polroles      | oid[]        |           |          |
 polqual       | pg_node_tree |           |          |
 polwithcheck  | pg_node_tree |           |          |
Indexes:
    "pg_policy_oid_index" UNIQUE, btree (oid)
    "pg_policy_polrelid_polname_index" UNIQUE, btree (polrelid, polname)
    

                 Table "pg_catalog.pg_policy"
    Column     |     Type     | Collation | Nullable | Default
---------------+--------------+-----------+----------+---------
 polname       | name         |           | not null |
 polrelid      | oid          |           | not null |
 polcmd        | "char"       |           | not null |
 polpermissive | boolean      |           | not null |
 polroles      | oid[]        |           |          |
 polqual       | pg_node_tree |           |          |
 polwithcheck  | pg_node_tree |           |          |
Indexes:
    "pg_policy_oid_index" UNIQUE, btree (oid)
    "pg_policy_polrelid_polname_index" UNIQUE, btree (polrelid, polname)
    

      Table "pg_catalog.pg_policy"
    Column    |     Type     | Modifiers
--------------+--------------+-----------
 polname      | name         | not null
 polrelid     | oid          | not null
 polcmd       | "char"       | not null
 polroles     | oid[]        |
 polqual      | pg_node_tree |
 polwithcheck | pg_node_tree |
Indexes:
    "pg_policy_oid_index" UNIQUE, btree (oid)
    "pg_policy_polrelid_polname_index" UNIQUE, btree (polrelid, polname)
    

      Table "pg_catalog.pg_policy"
    Column    |     Type     | Modifiers
--------------+--------------+-----------
 polname      | name         | not null
 polrelid     | oid          | not null
 polcmd       | "char"       | not null
 polroles     | oid[]        |
 polqual      | pg_node_tree |
 polwithcheck | pg_node_tree |
Indexes:
    "pg_policy_oid_index" UNIQUE, btree (oid)
    "pg_policy_polrelid_polname_index" UNIQUE, btree (polrelid, polname)
    

Change history

• PostgreSQL 10
  • column polpermissive added (commit 093129c9)
• PostgreSQL 9.5
  • added (initial commit 491c029d; note it was originally named pg_rowsecurity but changed to pg_policy in commit 143b39c1)

References

Categories

See also