↑↓ 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

pg_identify_object

Read the PG 18 manual

Returns a row containing enough information to uniquely identify the database object specified by catalog OID, object OID and sub-object ID.

Reading PG 18current·documented in 15 of 27 versions, 9.3 to 20

Signatures & examples

pg_identify_object ( classid oid, objid oid, objsubid integer ) → record ( type text, schema text, name text, identity text )
Returns a row containing enough information to uniquely identify the database object specified by catalog OID, object OID and sub-object ID. This information is intended to be machine-readable, and is never translated. type identifies the type of database object; schema is the schema name that the object belongs in, or NULL for object types that do not belong to schemas; name is the name of the object, quoted if necessary, if the name (along with schema name, if pertinent) is sufficient to uniquely identify the object, otherwise NULL; identity is the complete object identity, with the precise format depending on object type, and each name within the format being schema-qualified and quoted as necessary. Undefined objects are identified with NULL values.
Version history 4
  1. 13 → 14 changed
  2. 12 → 13 changed
  3. 9.4 → 9.5 changed
  4. 9.2 → 9.3 added

Definition snapshot: b7bd9cda · English manual source