Contents
pg_describe_object()
A function returning a human-readable description of a database object
pg_describe_object() is a system function providing a human-readable description of a database object via its catalog OID, object OID, and possbile sub-object ID, as contained for example pg_depend.
pg_describe_object() was added in PostgreSQL 9.1.
Usage
pg_describe_object (classidoid,objidoid,objsubidinteger) →text
Change history
- PostgreSQL 9.1
- added (commit 6cc2deb8)
Examples
Create an object with some dependencies:
postgres=# CREATE EXTENSION hstore_plperl CASCADE; NOTICE: installing required extension "hstore" NOTICE: installing required extension "plperl" CREATE EXTENSION
Examining the created dependencies reflected in pg_depend:
postgres=# SELECT pg_describe_object(refclassid, refobjid, refobjsubid)
FROM pg_depend
WHERE objid = (SELECT oid FROM pg_extension WHERE extname='hstore_plperl');
pg_describe_object
--------------------
extension plperl
extension hstore
schema public
(3 rows)
References
- PostgreSQL documentation: Object Information and Addressing Functions