↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Configuration Parameters

restrict_nonsystem_relation_kind

Set relation kinds for which access to non-system relations is prohibited. The value takes the form of a comma-separated list of relation kinds. Currently, the supported relation kinds are view and foreign-table.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

boot val
Unknown
category
Client Connection Defaults / Statement Behavior
context
user
documented
true
enumvals
Unknown
extra desc
Unknown
lang
en
max val
Unknown
metadata version
18
min val
Unknown
name
restrict_nonsystem_relation_kind
short desc
Prohibits access to non-system relations of specified kinds.
source
pg-settings-source-snapshot
unit
Unknown
vartype
string

Definition PG 18

Set relation kinds for which access to non-system relations is prohibited. The value takes the form of a comma-separated list of relation kinds. Currently, the supported relation kinds are view and foreign-table.

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:be71a1c70df4c4f3c067f5ea9c6d23627de69708ee3f29b2fae30099fd9890e9

Text language: en · wiki-repair-20261023:be71a1c70df4c4f3c067f5ea9c6d23627de69708ee3f29b2fae30099fd9890e9