Help Center > > Developer Guide> System Catalogs and System Views> System Catalogs> PG_RLSPOLICY

PG_RLSPOLICY

Updated at: Sep 17, 2021 GMT+08:00

PG_RLSPOLICY displays the information about row-level access control policies.

Table 1 PG_RLSPOLICY columns

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:

  • true: The row-level access control policy is a permissive policy.
  • false: The row-level access control policy is a restrictive policy.

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

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel