{"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","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"],"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":"b7bd9cda","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":"b7bd9cda","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":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-INFO-OBJECT-TABLE","file":"functions-info.html","slug":"18"},"group":"info","group_label":"System Information Functions And Operators","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":"","description_zh_html":"","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":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-INFO-OBJECT-TABLE","file":"functions-info.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-identify-object","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_identify_object","Summary":"返回一行，其中包含足以唯一标识数据库对象的信息，该对象由系统目录 OID、对象 OID 和子对象 ID 指定。这些信息供机器读取，永远不会被翻译。type标识数据库对象的类型；schema是对象所属的模式名，对于不属于模式的对象类型则为NULL；如果对象名（以及适用时的模式名）足以唯一标识该对象，name就是对象名，并在必要时加引号，否则为NULL；identity是完整的对象标识，其具体格式取决于对象类型，格式中的每个名称都会根据需要加上模式限定和引号。未定义的对象以NULL值标识。","BodyHTML":"返回一行，其中包含足以唯一标识数据库对象的信息，该对象由系统目录 OID、对象 OID 和子对象 ID 指定。这些信息供机器读取，永远不会被翻译。\u003cem\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e标识数据库对象的类型；\u003cem\u003e\u003ccode\u003eschema\u003c/code\u003e\u003c/em\u003e是对象所属的模式名，对于不属于模式的对象类型则为\u003ccode\u003eNULL\u003c/code\u003e；如果对象名（以及适用时的模式名）足以唯一标识该对象，\u003cem\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e就是对象名，并在必要时加引号，否则为\u003ccode\u003eNULL\u003c/code\u003e；\u003cem\u003e\u003ccode\u003eidentity\u003c/code\u003e\u003c/em\u003e是完整的对象标识，其具体格式取决于对象类型，格式中的每个名称都会根据需要加上模式限定和引号。未定义的对象以\u003ccode\u003eNULL\u003c/code\u003e值标识。\u003cpre\u003epg_identify_object ( classid oid, objid oid, objsubid integer ) → record ( type text, schema text, name text, identity text )\u003c/pre\u003e返回一行，其中包含足以唯一标识数据库对象的信息，该对象由系统目录 OID、对象 OID 和子对象 ID 指定。这些信息供机器读取，永远不会被翻译。\u003cem\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e标识数据库对象的类型；\u003cem\u003e\u003ccode\u003eschema\u003c/code\u003e\u003c/em\u003e是对象所属的模式名，对于不属于模式的对象类型则为\u003ccode\u003eNULL\u003c/code\u003e；如果对象名（以及适用时的模式名）足以唯一标识该对象，\u003cem\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e就是对象名，并在必要时加引号，否则为\u003ccode\u003eNULL\u003c/code\u003e；\u003cem\u003e\u003ccode\u003eidentity\u003c/code\u003e\u003c/em\u003e是完整的对象标识，其具体格式取决于对象类型，格式中的每个名称都会根据需要加上模式限定和引号。未定义的对象以\u003ccode\u003eNULL\u003c/code\u003e值标识。","SourceRevision":"ca936764","ContentHash":"b6aab464ba6da9cb20f13ae6a180131f1425e60307e5b946dde1d0dacfac1ddc","Payload":{"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值标识。","signatures":[{"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值标识。","returns":"record","text":"pg_identify_object ( classid oid, objid oid, objsubid integer ) → record ( type text, schema text, name text, identity text )","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","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":"","description_zh_html":"","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":""}}],"Spellings":null,"SQLState":null,"Evidence":null}