{"Entry":{"collection":"func","key":"pg-identify-object","name":"pg_identify_object","aliases":[],"metadata":{"changed_in":["9.5"],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"9.2","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"9.3"},{"descriptions_changed":false,"doc_overhaul":false,"from":"9.4","group_changed":null,"signatures":{"added":["pg_identify_object ( classid oid, objid oid, objsubid integer ) → type text, schema text, name text, identity text"],"removed":["pg_identify_object ( catalog_id oid, object_id oid, object_sub_id integer ) → type text, schema text, name text, identity text"]},"status":"changed","to":"9.5"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"},{"descriptions_changed":true,"doc_overhaul":false,"from":"13","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"14"}],"content_hash":"af58eebe4e998763a20d750d8f7c0b2ca572ce1c34a270e6e7a87c1867171ee6","derived_content_hash":"11ae9433add79d8c960ee39c75999d4b85b1936ff098e6a3e9a0fc8e39d38307","documentation_refresh":{"batch":"20261113","original_source_rev":"wiki-repair-20261023:9695636ff97eda0c169c9c5e512072cb7610d7fe1c32f75f0e8f979b42e1d0aa","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"first_version":"9.3","group":"info","group_label":"System Information Functions And Operators","groups":["info"],"imported_at":"2026-09-27T17:57:29.23748+08:00","last_version":"20","name":"pg_identify_object","name_key":"pg_identify_object","position":28079,"present_in":["9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"repair_provenance":{"original_source_revision":"b7bd9cda","receipt_sha256":"98e4a3ab8ff35e02fb09add4eb0b15189c5e4df7e522e43e0a96ae4711694b84","repair":"wiki-repair-20261023"},"signature":"pg_identify_object ( classid oid, objid oid, objsubid integer ) → record ( type text, schema text, name text, identity text )","signature_count":1,"slug":"pg-identify-object","source_rev":"wiki-repair-20261023:9695636ff97eda0c169c9c5e512072cb7610d7fe1c32f75f0e8f979b42e1d0aa","summary":"Returns a row containing enough information to uniquely identify the database object specified by catalog OID, object OID and sub-object ID.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-identify-object","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-identify-object","SourceRevision":"wiki-repair-20261023:9695636ff97eda0c169c9c5e512072cb7610d7fe1c32f75f0e8f979b42e1d0aa","Facts":{"description":"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.","description_html":"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. \u003cem class=\"parameter\"\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e identifies the type of database object; \u003cem class=\"parameter\"\u003e\u003ccode\u003eschema\u003c/code\u003e\u003c/em\u003e is the schema name that the object belongs in, or \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e for object types that do not belong to schemas; \u003cem class=\"parameter\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e 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 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e; \u003cem class=\"parameter\"\u003e\u003ccode\u003eidentity\u003c/code\u003e\u003c/em\u003e 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 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e values.","description_zh":"返回一行，其中包含足以唯一标识数据库对象的信息，该对象由系统目录 OID、对象 OID 和子对象 ID 指定。这些信息供机器读取，永远不会被翻译。type 标识数据库对象的类型；schema 是对象所属的模式名，对于不属于模式的对象类型则为 NULL；如果对象名（以及适用时的模式名）足以唯一标识该对象，name 就是对象名，并在必要时加引号，否则为 NULL；identity 是完整的对象标识，其具体格式取决于对象类型，格式中的每个名称都会根据需要加上模式限定和引号。未定义的对象以 NULL 值标识。","description_zh_html":"返回一行，其中包含足以唯一标识数据库对象的信息，该对象由系统目录 OID、对象 OID 和子对象 ID 指定。这些信息供机器读取，永远不会被翻译。\u003cem class=\"parameter\"\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e 标识数据库对象的类型；\u003cem class=\"parameter\"\u003e\u003ccode\u003eschema\u003c/code\u003e\u003c/em\u003e 是对象所属的模式名，对于不属于模式的对象类型则为 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e；如果对象名（以及适用时的模式名）足以唯一标识该对象，\u003cem class=\"parameter\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e 就是对象名，并在必要时加引号，否则为 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e；\u003cem class=\"parameter\"\u003e\u003ccode\u003eidentity\u003c/code\u003e\u003c/em\u003e 是完整的对象标识，其具体格式取决于对象类型，格式中的每个名称都会根据需要加上模式限定和引号。未定义的对象以 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e 值标识。","doc":{"anchor":"FUNCTIONS-INFO-OBJECT-TABLE","file":"functions-info.html","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","slug":"18"},"documentation_revision":{"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"},"group":"info","group_label":"系统信息函数和操作符","lang":"en","layout":"table-new","pages":["functions-info.html"],"prose_only":false,"signatures":[{"description":"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.","description_html":"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. \u003cem class=\"parameter\"\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e identifies the type of database object; \u003cem class=\"parameter\"\u003e\u003ccode\u003eschema\u003c/code\u003e\u003c/em\u003e is the schema name that the object belongs in, or \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e for object types that do not belong to schemas; \u003cem class=\"parameter\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e 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 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e; \u003cem class=\"parameter\"\u003e\u003ccode\u003eidentity\u003c/code\u003e\u003c/em\u003e 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 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e values.","description_zh":"返回一行，其中包含足以唯一标识数据库对象的信息，该对象由系统目录 OID、对象 OID 和子对象 ID 指定。这些信息供机器读取，永远不会被翻译。type 标识数据库对象的类型；schema 是对象所属的模式名，对于不属于模式的对象类型则为 NULL；如果对象名（以及适用时的模式名）足以唯一标识该对象，name 就是对象名，并在必要时加引号，否则为 NULL；identity 是完整的对象标识，其具体格式取决于对象类型，格式中的每个名称都会根据需要加上模式限定和引号。未定义的对象以 NULL 值标识。","description_zh_html":"返回一行，其中包含足以唯一标识数据库对象的信息，该对象由系统目录 OID、对象 OID 和子对象 ID 指定。这些信息供机器读取，永远不会被翻译。\u003cem class=\"parameter\"\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e 标识数据库对象的类型；\u003cem class=\"parameter\"\u003e\u003ccode\u003eschema\u003c/code\u003e\u003c/em\u003e 是对象所属的模式名，对于不属于模式的对象类型则为 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e；如果对象名（以及适用时的模式名）足以唯一标识该对象，\u003cem class=\"parameter\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e 就是对象名，并在必要时加引号，否则为 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e；\u003cem class=\"parameter\"\u003e\u003ccode\u003eidentity\u003c/code\u003e\u003c/em\u003e 是完整的对象标识，其具体格式取决于对象类型，格式中的每个名称都会根据需要加上模式限定和引号。未定义的对象以 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e 值标识。","examples":[],"html":"\u003ccode class=\"function\"\u003epg_identify_object\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003eclassid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eobjid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eobjsubid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003erecord\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eschema\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eidentity\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e )","returns":"record","text":"pg_identify_object ( classid oid, objid oid, objsubid integer ) → record ( type text, schema text, name text, identity text )","zh_from":"same-version-manual"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/functions-info.html","sha256":"7c33185e79430cfbda432dc4db277115c7ac846afccadfcf904ceb1bf2aa1ba5"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-INFO-OBJECT-TABLE","file":"functions-info.html","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-identify-object","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_identify_object","Summary":"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.","BodyHTML":"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. \u003cem\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e identifies the type of database object; \u003cem\u003e\u003ccode\u003eschema\u003c/code\u003e\u003c/em\u003e is the schema name that the object belongs in, or \u003ccode\u003eNULL\u003c/code\u003e for object types that do not belong to schemas; \u003cem\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e 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 \u003ccode\u003eNULL\u003c/code\u003e; \u003cem\u003e\u003ccode\u003eidentity\u003c/code\u003e\u003c/em\u003e 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 \u003ccode\u003eNULL\u003c/code\u003e values.","SourceRevision":"wiki-repair-20261023:9695636ff97eda0c169c9c5e512072cb7610d7fe1c32f75f0e8f979b42e1d0aa","ContentHash":"3f0f4ac8ee705576d2ec3b2b5a36cabeebe8679264c9626a0af618b5b76ffdc3","Payload":{"description":"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.","description_html":"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. \u003cem class=\"parameter\"\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e identifies the type of database object; \u003cem class=\"parameter\"\u003e\u003ccode\u003eschema\u003c/code\u003e\u003c/em\u003e is the schema name that the object belongs in, or \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e for object types that do not belong to schemas; \u003cem class=\"parameter\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e 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 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e; \u003cem class=\"parameter\"\u003e\u003ccode\u003eidentity\u003c/code\u003e\u003c/em\u003e 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 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e values.","signatures":[{"description":"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.","description_html":"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. \u003cem class=\"parameter\"\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e identifies the type of database object; \u003cem class=\"parameter\"\u003e\u003ccode\u003eschema\u003c/code\u003e\u003c/em\u003e is the schema name that the object belongs in, or \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e for object types that do not belong to schemas; \u003cem class=\"parameter\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e 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 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e; \u003cem class=\"parameter\"\u003e\u003ccode\u003eidentity\u003c/code\u003e\u003c/em\u003e 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 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e values.","description_zh":"返回一行，其中包含足以唯一标识数据库对象的信息，该对象由系统目录 OID、对象 OID 和子对象 ID 指定。这些信息供机器读取，永远不会被翻译。type 标识数据库对象的类型；schema 是对象所属的模式名，对于不属于模式的对象类型则为 NULL；如果对象名（以及适用时的模式名）足以唯一标识该对象，name 就是对象名，并在必要时加引号，否则为 NULL；identity 是完整的对象标识，其具体格式取决于对象类型，格式中的每个名称都会根据需要加上模式限定和引号。未定义的对象以 NULL 值标识。","description_zh_html":"返回一行，其中包含足以唯一标识数据库对象的信息，该对象由系统目录 OID、对象 OID 和子对象 ID 指定。这些信息供机器读取，永远不会被翻译。\u003cem class=\"parameter\"\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e 标识数据库对象的类型；\u003cem class=\"parameter\"\u003e\u003ccode\u003eschema\u003c/code\u003e\u003c/em\u003e 是对象所属的模式名，对于不属于模式的对象类型则为 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e；如果对象名（以及适用时的模式名）足以唯一标识该对象，\u003cem class=\"parameter\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e 就是对象名，并在必要时加引号，否则为 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e；\u003cem class=\"parameter\"\u003e\u003ccode\u003eidentity\u003c/code\u003e\u003c/em\u003e 是完整的对象标识，其具体格式取决于对象类型，格式中的每个名称都会根据需要加上模式限定和引号。未定义的对象以 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e 值标识。","examples":[],"html":"\u003ccode class=\"function\"\u003epg_identify_object\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003eclassid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eobjid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eobjsubid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003erecord\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eschema\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eidentity\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e )","returns":"record","text":"pg_identify_object ( classid oid, objid oid, objsubid integer ) → record ( type text, schema text, name text, identity text )","zh_from":"same-version-manual"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"4835ac4474fbea2f8d7ef423e31f0eb01459a95f4d8209c92e6704aa8f6c7ea5","Text":"pg_identify_object ( classid oid, objid oid, objsubid integer ) → record ( type text, schema text, name text, identity text )","Returns":"record","Payload":{"description":"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.","description_html":"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. \u003cem class=\"parameter\"\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e identifies the type of database object; \u003cem class=\"parameter\"\u003e\u003ccode\u003eschema\u003c/code\u003e\u003c/em\u003e is the schema name that the object belongs in, or \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e for object types that do not belong to schemas; \u003cem class=\"parameter\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e 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 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e; \u003cem class=\"parameter\"\u003e\u003ccode\u003eidentity\u003c/code\u003e\u003c/em\u003e 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 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e values.","description_zh":"返回一行，其中包含足以唯一标识数据库对象的信息，该对象由系统目录 OID、对象 OID 和子对象 ID 指定。这些信息供机器读取，永远不会被翻译。type 标识数据库对象的类型；schema 是对象所属的模式名，对于不属于模式的对象类型则为 NULL；如果对象名（以及适用时的模式名）足以唯一标识该对象，name 就是对象名，并在必要时加引号，否则为 NULL；identity 是完整的对象标识，其具体格式取决于对象类型，格式中的每个名称都会根据需要加上模式限定和引号。未定义的对象以 NULL 值标识。","description_zh_html":"返回一行，其中包含足以唯一标识数据库对象的信息，该对象由系统目录 OID、对象 OID 和子对象 ID 指定。这些信息供机器读取，永远不会被翻译。\u003cem class=\"parameter\"\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e 标识数据库对象的类型；\u003cem class=\"parameter\"\u003e\u003ccode\u003eschema\u003c/code\u003e\u003c/em\u003e 是对象所属的模式名，对于不属于模式的对象类型则为 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e；如果对象名（以及适用时的模式名）足以唯一标识该对象，\u003cem class=\"parameter\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e 就是对象名，并在必要时加引号，否则为 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e；\u003cem class=\"parameter\"\u003e\u003ccode\u003eidentity\u003c/code\u003e\u003c/em\u003e 是完整的对象标识，其具体格式取决于对象类型，格式中的每个名称都会根据需要加上模式限定和引号。未定义的对象以 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e 值标识。","examples":[],"html":"\u003ccode class=\"function\"\u003epg_identify_object\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003eclassid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eobjid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eobjsubid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003erecord\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eschema\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eidentity\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e )","returns":"record","text":"pg_identify_object ( classid oid, objid oid, objsubid integer ) → record ( type text, schema text, name text, identity text )","zh_from":"same-version-manual"}}],"Spellings":null,"SQLState":null,"Evidence":null}