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

Read the PG 18 manual

Returns a row containing enough information to uniquely identify the database object specified by a type code and object name and argument arrays.

Reading PG 18current·documented in 13 of 27 versions, 9.5 to 20

Signatures & examples

pg_get_object_address ( type text, object_names text[], object_args text[] ) → record ( classid oid, objid oid, objsubid integer )
Returns a row containing enough information to uniquely identify the database object specified by a type code and object name and argument arrays. The returned values are the ones that would be used in system catalogs such as pg_depend; they can be passed to other system functions such as pg_describe_object or pg_identify_object. classid is the OID of the system catalog containing the object; objid is the OID of the object itself, and objsubid is the sub-object ID, or zero if none. This function is the inverse of pg_identify_object_as_address. Undefined objects are identified with NULL values.
Version history 4
  1. 13 → 14 changed
  2. 12 → 13 changed
  3. 10 → 11 changed
  4. 9.4 → 9.5 added

Definition snapshot: b7bd9cda · English manual source