has_schema_privilege

Does user have privilege for schema? Allowable privilege types are CREATE and USAGE.

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

Reading PG 18·Select a recorded version

7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

group: info
group label: 系统信息函数和操作符
lang: en
layout: table-new
pages: functions-info.html
prose only: false

Definition PG 18

Does user have privilege for schema? Allowable privilege types are CREATE and USAGE.

Signatures and overloads

has_schema_privilege ( [user name or oid, ] schema text or oid, privilege text ) → boolean → boolean

Does user have privilege for schema? Allowable privilege types are CREATE and USAGE.

Compare versions

Complete source facts

documentation revision

{"inputs":[{"file":"functions-info.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","version":"18.7"},{"file":"functions-info.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"f9684137c0b9fb17a691c4d905529d114472a507a007c15058f2703962b611d2","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:31164c282c5d6c78475f85b3c059db7db007b8dd69296a3d7a311ee159c3ec83

Text language: en · wiki-repair-20261023:31164c282c5d6c78475f85b3c059db7db007b8dd69296a3d7a311ee159c3ec83