select open change scope Open full search

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

FUNCTIONS / SYSTEM INFORMATION FUNCTIONS AND OPERATORS

Returns the ACL for a database object, specified by catalog OID, object OID and sub-object ID.

Signatures & examples

pg_get_acl ( classid oid, objid oid, objsubid integer ) → 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.
Version history 1
  1. PG 17 → 18added

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source