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 |