PostgreSQL Documentation: restrict_nonsystem_relation

Type:	`string`
Context:	`user`
Restart:	`false`
Since:	`12`

Prohibits access to non-system relations of specified kinds

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.

Official docs

Search in source code

On StackOverflow

What exactly means the collation 'de-DE-u-kn-true'
Lazily (de-)serialize JSON with EF Core
Connect to a heroku database with pgadmin
Get breakdown from de-normalized SQL table
PostGIS & Hibernate can't de-serialize point geometry

On pgsql-hackers

Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them
restrict_nonsystem_relation_kind led to regression (kinda)
pg18: Virtual generated columns are not (yet) safe when superuser selects from them
Re: Better visualization of default values
Re: restrict_nonsystem_relation_kind led to regression (kinda)

restrict_nonsystem_relation_kind

On StackOverflow

On pgsql-hackers

Comments