PG_RLSPOLICY¶
PG_RLSPOLICY displays the information about row-level access control policies.
Name | Type | Description |
|---|---|---|
polname | name | Name of a row-level access control policy |
polrelid | oid | Table OID of a row-level access control policy |
polcmd | char | SQL operations affected by a row-level access control policy. The options are *(ALL), r(SELECT), w(UPDATE), and d(DELETE). |
polpermissive | boolean | Type of a row-level access control policy Note Values of polpermissive:
|
polroles | oid[] | OID of database user affected by a row-level access control policy |
polqual | pg_node_tree | SQL condition expression of a row-level access control policy |