Returns the comment for a database object specified by its OID and the name of the containing system catalog. For example, obj_description(123456, 'pg_class') would retrieve the comment for the table with OID 123456.
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
obj_description(123456, 'pg_class') would retrieve the comment for the table with OID 123456.obj_description ( object oid, catalog name ) → text → textReturns the comment for a database object specified by its OID and the name of the containing system catalog. For example,
obj_description(123456, 'pg_class') would retrieve the comment for the table with OID 123456.obj_description ( object oid ) → text → textReturns the comment for a database object specified by its OID alone. This is deprecated since there is no guarantee that OIDs are unique across different system catalogs; therefore, the wrong comment might be returned.
{"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"}Full definition and evidence JSON
center · PostgreSQL 18 · wiki-repair-20261023:63a646a15af5b5b04878300319841d5d6eb7c6162f2f60de30c8e9fff58d5634
Text language: en · wiki-repair-20261023:63a646a15af5b5b04878300319841d5d6eb7c6162f2f60de30c8e9fff58d5634