• Browse categories
• PostgreSQL releases
  • PostgreSQL 15 (beta1)
  • PostgreSQL 14 (latest)
  • PostgreSQL 13
  • PostgreSQL 12
  • PostgreSQL 11
  • PostgreSQL 10
  • PostgreSQL 9.6 (EOL)

Version charts

Useful overviews

Useful links

pg_policy

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

pg_policy was added in PostgreSQL 9.5.

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" PRIMARY KEY, btree (oid)
    "pg_policy_polrelid_polname_index" UNIQUE CONSTRAINT, 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" PRIMARY KEY, btree (oid)
    "pg_policy_polrelid_polname_index" UNIQUE CONSTRAINT, 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 
---------------+--------------+-----------+----------+---------
 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