pg_get_acl

Returns the ACL for a database object, specified by catalog OID, object OID and sub-object ID. This function returns NULL values for undefined objects.

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

18 19 20

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

Definition PG 18

Returns the ACL for a database object, specified by catalog OID, object OID and sub-object ID. This function returns NULL values for undefined objects.

Signatures and overloads

pg_get_acl ( classid oid, objid oid, objsubid integer ) → aclitem[] → aclitem[]

Returns the ACL for a database object, specified by catalog OID, object OID and sub-object ID. This function returns NULL values for undefined objects.

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:6666b894ff5b64978c2ff420c5bed2e9e52a9e69ba6ff0d6aa61b1f192c0469f

Text language: en · wiki-repair-20261023:6666b894ff5b64978c2ff420c5bed2e9e52a9e69ba6ff0d6aa61b1f192c0469f