{"Entry":{"collection":"catalog","key":"pg_depend","name":"pg_depend","aliases":[],"metadata":{"changed_in":[],"changes":[{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"8.0","listing":[],"order":false,"removed":[],"status":"reworded","to":"8.1","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"A code defining the specific semantics of this dependency relationship; see text.","name":"deptype","to":"A code defining the specific semantics of this dependency relationship; see text"},{"from":"For a table column, this is the column number (the objid and classid refer to the table itself). For all other object types, this column is zero.","name":"objsubid","to":"For a table column, this is the column number (the objid and classid refer to the table itself). For all other object types, this column is zero"},{"from":"For a table column, this is the column number (the refobjid and refclassid refer to the table itself). For all other object types, this column is zero.","name":"refobjsubid","to":"For a table column, this is the column number (the refobjid and refclassid refer to the table itself). For all other object types, this column is zero"}],"from":"8.1","listing":[],"order":false,"removed":[],"status":"reworded","to":"8.2","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"For a table column, this is the column number (the objid and classid refer to the table itself). For all other object types, this column is zero","name":"objsubid","to":"For a table column, this is the column number (the objid and classid refer to the table itself). For all other object types, this column is zero."},{"from":"For a table column, this is the column number (the refobjid and refclassid refer to the table itself). For all other object types, this column is zero","name":"refobjsubid","to":"For a table column, this is the column number (the refobjid and refclassid refer to the table itself). For all other object types, this column is zero."}],"from":"8.4","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.0","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"The OID of the system catalog the dependent object is in","name":"classid","to":"The OID of the system catalog the dependent object is in, or zero for a DEPENDENCY_PIN entry"},{"from":"The OID of the specific dependent object","name":"objid","to":"The OID of the specific dependent object, or zero for a DEPENDENCY_PIN entry"}],"from":"13","listing":[],"order":false,"removed":[],"status":"reworded","to":"14","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"The OID of the system catalog the dependent object is in, or zero for a DEPENDENCY_PIN entry","name":"classid","to":"The OID of the system catalog the dependent object is in"},{"from":"The OID of the specific dependent object, or zero for a DEPENDENCY_PIN entry","name":"objid","to":"The OID of the specific dependent object"}],"from":"14","listing":[],"order":false,"removed":[],"status":"reworded","to":"15","types":[],"unlisted":[]}],"column_count":7,"content_hash":"d775f5955f6db184e56df0d0711afc66c6d5f744a01377ac4d39e2708f7487ed","first_version":"7.4","imported_at":"2026-09-30T00:40:55.507642+08:00","kind":"catalog","last_version":"20","name":"pg_depend","position":23,"present_in":["7.4","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"r","shared":false,"source_rev":"english-manuals:71953b694f236deae10e284631f935d8ab1de7ebf1e04f048c468177c4309d95","summary":"The catalog pg_depend records the dependency relationships between database objects.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_depend","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_depend","SourceRevision":"english-manuals:71953b694f236deae10e284631f935d8ab1de7ebf1e04f048c468177c4309d95","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"The OID of the system catalog the dependent object is in","description_zh":"","documented":true,"documented_name":"classid","hidden":false,"name":"classid","not_null":true,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":2,"description":"The OID of the specific dependent object","description_zh":"","documented":true,"documented_name":"objid","hidden":false,"name":"objid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":3,"description":"For a table column, this is the column number (the objid and classid refer to the table itself). For all other object types, this column is zero.","description_zh":"","documented":true,"documented_name":"objsubid","hidden":false,"name":"objsubid","not_null":true,"references":"","type":"int4","type_modifier":-1,"type_oid":23},{"array_dimensions":0,"attnum":4,"description":"The OID of the system catalog the referenced object is in","description_zh":"","documented":true,"documented_name":"refclassid","hidden":false,"name":"refclassid","not_null":true,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":5,"description":"The OID of the specific referenced object","description_zh":"","documented":true,"documented_name":"refobjid","hidden":false,"name":"refobjid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":6,"description":"For a table column, this is the column number (the refobjid and refclassid refer to the table itself). For all other object types, this column is zero.","description_zh":"","documented":true,"documented_name":"refobjsubid","hidden":false,"name":"refobjsubid","not_null":true,"references":"","type":"int4","type_modifier":-1,"type_oid":23},{"array_dimensions":0,"attnum":7,"description":"A code defining the specific semantics of this dependency relationship; see text","description_zh":"","documented":true,"documented_name":"deptype","hidden":false,"name":"deptype","not_null":true,"references":"","type":"char","type_modifier":-1,"type_oid":18}],"description":"The catalog pg_depend records the dependency relationships between database objects. This information allows DROP commands to find which other objects must be dropped by DROP CASCADE or prevent dropping in the DROP RESTRICT case.\n\nSee also pg_shdepend, which performs a similar function for dependencies involving objects that are shared across a database cluster.","description_zh":"","doc":{"anchor":"id-1.10.4.20.5","file":"catalog-pg-depend.html","lang":"en","sha256":"d982ceb8ada0c33d728c3de698cd7e9dfa6b7c8111962436fa4f589e59779957","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["classid","objid","objsubid","refclassid","refobjid","refobjsubid","deptype"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.20.5","file":"catalog-pg-depend.html","lang":"en","sha256":"d982ceb8ada0c33d728c3de698cd7e9dfa6b7c8111962436fa4f589e59779957","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["classid","objid","objsubid","refclassid","refobjid","refobjsubid","deptype"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_depend","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_depend","Summary":"目录pg_depend记录数据库对象之间的依赖关系。这些信息允许DROP命令查找必须被DROP CASCADE删除的其他对象，或者在DROP RESTRICT情况下阻止删除。\n\n另请参阅pg_shdepend，它对涉及数据库集簇共享对象的依赖提供了相似的功能。","BodyHTML":"\u003cp\u003e目录pg_depend记录数据库对象之间的依赖关系。这些信息允许DROP命令查找必须被DROP CASCADE删除的其他对象，或者在DROP RESTRICT情况下阻止删除。\n\n另请参阅pg_shdepend，它对涉及数据库集簇共享对象的依赖提供了相似的功能。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"48b54726f2f013d3dbc944c45673582186aa6e8dba8504246067ea6faa70880d","Payload":{"columns":[{"description_zh":"依赖对象所在系统目录的OID","name":"classid","type":"oid","zh_from":"doc"},{"description_zh":"特定依赖对象的OID","name":"objid","type":"oid","zh_from":"doc"},{"description_zh":"对于一个表列，这里是列号（objid和classid指表本身）。对于所有其他对象类型，此列为0。","name":"objsubid","type":"integer","zh_from":"doc"},{"description_zh":"被引用对象所在的系统目录的OID","name":"refclassid","type":"oid","zh_from":"doc"},{"description_zh":"指定被引用对象的OID","name":"refobjid","type":"oid","zh_from":"doc"},{"description_zh":"对于一个表列，这里是列号（refobjid和refclassid指表本身）。对于所有其他对象类型，此列为0。","name":"refobjsubid","type":"integer","zh_from":"doc"},{"description_zh":"定义此依赖关系语义的一个代码，见下文","name":"deptype","type":"\"char\"","zh_from":"doc"}],"description_zh":"目录pg_depend记录数据库对象之间的依赖关系。这些信息允许DROP命令查找必须被DROP CASCADE删除的其他对象，或者在DROP RESTRICT情况下阻止删除。\n\n另请参阅pg_shdepend，它对涉及数据库集簇共享对象的依赖提供了相似的功能。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","7.4","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}