Movatterモバイル変換


[0]ホーム

URL:



Facebook
Postgres Pro
Facebook
Downloads
53.14. pg_policies
Prev UpChapter 53. System ViewsHome Next

53.14. pg_policies

The viewpg_policies provides access to useful information about each row-level security policy in the database.

Table 53.14. pg_policies Columns

Column Type

Description

schemanamename (referencespg_namespace.nspname)

Name of schema containing table policy is on

tablenamename (referencespg_class.relname)

Name of table policy is on

policynamename (referencespg_policy.polname)

Name of policy

permissivetext

Is the policy permissive or restrictive?

rolesname[]

The roles to which this policy applies

cmdtext

The command type to which the policy is applied

qualtext

The expression added to the security barrier qualifications for queries that this policy applies to

with_checktext

The expression added to the WITH CHECK qualifications for queries that attempt to add rows to this table



Prev Up Next
53.13. pg_matviews Home 53.15. pg_prepared_statements
pdfepub
Go to Postgres Pro Standard 15
By continuing to browse this website, you agree to the use of cookies. Go toPrivacy Policy.

[8]ページ先頭

©2009-2025 Movatter.jp