{"Entry":{"collection":"func","key":"pg-get-catalog-foreign-keys","name":"pg_get_catalog_foreign_keys","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"13","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"14"}],"content_hash":"b30e1b42d4c19d7da4aa8b1cd1c14d5921475b8b5766b4dae54c20d877128e75","first_version":"14","group":"info","group_label":"System Information Functions And Operators","groups":["info"],"imported_at":"2026-09-27T17:57:29.161001+08:00","last_version":"20","name":"pg_get_catalog_foreign_keys","name_key":"pg_get_catalog_foreign_keys","position":28053,"present_in":["14","15","16","17","18","19","20"],"signature":"pg_get_catalog_foreign_keys () → setof record ( fktable regclass, fkcols text[], pktable regclass, pkcols text[], is_array boolean, is_opt boolean )","signature_count":1,"slug":"pg-get-catalog-foreign-keys","source_rev":"b7bd9cda","summary":"Returns a set of records describing the foreign key relationships that exist within the PostgreSQL system catalogs.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-get-catalog-foreign-keys","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-get-catalog-foreign-keys","SourceRevision":"b7bd9cda","Facts":{"description":"Returns a set of records describing the foreign key relationships that exist within the PostgreSQL system catalogs. The fktable column contains the name of the referencing catalog, and the fkcols column contains the name(s) of the referencing column(s). Similarly, the pktable column contains the name of the referenced catalog, and the pkcols column contains the name(s) of the referenced column(s). If is_array is true, the last referencing column is an array, each of whose elements should match some entry in the referenced catalog. If is_opt is true, the referencing column(s) are allowed to contain zeroes instead of a valid reference.","description_html":"Returns a set of records describing the foreign key relationships that exist within the \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e system catalogs. The \u003cem class=\"parameter\"\u003e\u003ccode\u003efktable\u003c/code\u003e\u003c/em\u003e column contains the name of the referencing catalog, and the \u003cem class=\"parameter\"\u003e\u003ccode\u003efkcols\u003c/code\u003e\u003c/em\u003e column contains the name(s) of the referencing column(s). Similarly, the \u003cem class=\"parameter\"\u003e\u003ccode\u003epktable\u003c/code\u003e\u003c/em\u003e column contains the name of the referenced catalog, and the \u003cem class=\"parameter\"\u003e\u003ccode\u003epkcols\u003c/code\u003e\u003c/em\u003e column contains the name(s) of the referenced column(s). If \u003cem class=\"parameter\"\u003e\u003ccode\u003eis_array\u003c/code\u003e\u003c/em\u003e is true, the last referencing column is an array, each of whose elements should match some entry in the referenced catalog. If \u003cem class=\"parameter\"\u003e\u003ccode\u003eis_opt\u003c/code\u003e\u003c/em\u003e is true, the referencing column(s) are allowed to contain zeroes instead of a valid reference.","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-INFO-CATALOG-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 set of records describing the foreign key relationships that exist within the PostgreSQL system catalogs. The fktable column contains the name of the referencing catalog, and the fkcols column contains the name(s) of the referencing column(s). Similarly, the pktable column contains the name of the referenced catalog, and the pkcols column contains the name(s) of the referenced column(s). If is_array is true, the last referencing column is an array, each of whose elements should match some entry in the referenced catalog. If is_opt is true, the referencing column(s) are allowed to contain zeroes instead of a valid reference.","description_html":"Returns a set of records describing the foreign key relationships that exist within the \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e system catalogs. The \u003cem class=\"parameter\"\u003e\u003ccode\u003efktable\u003c/code\u003e\u003c/em\u003e column contains the name of the referencing catalog, and the \u003cem class=\"parameter\"\u003e\u003ccode\u003efkcols\u003c/code\u003e\u003c/em\u003e column contains the name(s) of the referencing column(s). Similarly, the \u003cem class=\"parameter\"\u003e\u003ccode\u003epktable\u003c/code\u003e\u003c/em\u003e column contains the name of the referenced catalog, and the \u003cem class=\"parameter\"\u003e\u003ccode\u003epkcols\u003c/code\u003e\u003c/em\u003e column contains the name(s) of the referenced column(s). If \u003cem class=\"parameter\"\u003e\u003ccode\u003eis_array\u003c/code\u003e\u003c/em\u003e is true, the last referencing column is an array, each of whose elements should match some entry in the referenced catalog. If \u003cem class=\"parameter\"\u003e\u003ccode\u003eis_opt\u003c/code\u003e\u003c/em\u003e is true, the referencing column(s) are allowed to contain zeroes instead of a valid reference.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_get_catalog_foreign_keys\u003c/code\u003e () → \u003ccode class=\"returnvalue\"\u003esetof record\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003efktable\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eregclass\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003efkcols\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext[]\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003epktable\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eregclass\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003epkcols\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext[]\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eis_array\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eis_opt\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e )","returns":"setof record","text":"pg_get_catalog_foreign_keys () → setof record ( fktable regclass, fkcols text[], pktable regclass, pkcols text[], is_array boolean, is_opt boolean )","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-INFO-CATALOG-TABLE","file":"functions-info.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-get-catalog-foreign-keys","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_get_catalog_foreign_keys","Summary":"返回一组记录，描述存在于PostgreSQL系统目录中的外键关系。fktable 列包含引用目录的名称，fkcols列包含引用列的名称。类似地，pktable列包含被引用目录的名称，而pkcols列包含被引用列的名称。如果is_array为真，则最后一个引用列是一个数组，其每个元素都应该与被引用目录中的某个条目匹配。如果is_opt为真，则允许引用列包含零而不是有效引用。","BodyHTML":"返回一组记录，描述存在于\u003cspan\u003ePostgreSQL\u003c/span\u003e系统目录中的外键关系。\u003cem\u003e\u003ccode\u003efktable\u003c/code\u003e\u003c/em\u003e 列包含引用目录的名称，\u003cem\u003e\u003ccode\u003efkcols\u003c/code\u003e\u003c/em\u003e列包含引用列的名称。类似地，\u003cem\u003e\u003ccode\u003epktable\u003c/code\u003e\u003c/em\u003e列包含被引用目录的名称，而\u003cem\u003e\u003ccode\u003epkcols\u003c/code\u003e\u003c/em\u003e列包含被引用列的名称。如果\u003cem\u003e\u003ccode\u003eis_array\u003c/code\u003e\u003c/em\u003e为真，则最后一个引用列是一个数组，其每个元素都应该与被引用目录中的某个条目匹配。如果\u003cem\u003e\u003ccode\u003eis_opt\u003c/code\u003e\u003c/em\u003e为真，则允许引用列包含零而不是有效引用。\u003cpre\u003epg_get_catalog_foreign_keys () → setof record ( fktable regclass, fkcols text[], pktable regclass, pkcols text[], is_array boolean, is_opt boolean )\u003c/pre\u003e返回一组记录，描述存在于\u003cspan\u003ePostgreSQL\u003c/span\u003e系统目录中的外键关系。\u003cem\u003e\u003ccode\u003efktable\u003c/code\u003e\u003c/em\u003e 列包含引用目录的名称，\u003cem\u003e\u003ccode\u003efkcols\u003c/code\u003e\u003c/em\u003e列包含引用列的名称。类似地，\u003cem\u003e\u003ccode\u003epktable\u003c/code\u003e\u003c/em\u003e列包含被引用目录的名称，而\u003cem\u003e\u003ccode\u003epkcols\u003c/code\u003e\u003c/em\u003e列包含被引用列的名称。如果\u003cem\u003e\u003ccode\u003eis_array\u003c/code\u003e\u003c/em\u003e为真，则最后一个引用列是一个数组，其每个元素都应该与被引用目录中的某个条目匹配。如果\u003cem\u003e\u003ccode\u003eis_opt\u003c/code\u003e\u003c/em\u003e为真，则允许引用列包含零而不是有效引用。","SourceRevision":"ca936764","ContentHash":"74ea72e15593761e1a7035d63044e91121d591a5499d76c06885bbad0a1fa8ec","Payload":{"description_zh":"返回一组记录，描述存在于PostgreSQL系统目录中的外键关系。fktable 列包含引用目录的名称，fkcols列包含引用列的名称。类似地，pktable列包含被引用目录的名称，而pkcols列包含被引用列的名称。如果is_array为真，则最后一个引用列是一个数组，其每个元素都应该与被引用目录中的某个条目匹配。如果is_opt为真，则允许引用列包含零而不是有效引用。","description_zh_html":"返回一组记录，描述存在于\u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e系统目录中的外键关系。\u003cem class=\"parameter\"\u003e\u003ccode\u003efktable\u003c/code\u003e\u003c/em\u003e 列包含引用目录的名称，\u003cem class=\"parameter\"\u003e\u003ccode\u003efkcols\u003c/code\u003e\u003c/em\u003e列包含引用列的名称。类似地，\u003cem class=\"parameter\"\u003e\u003ccode\u003epktable\u003c/code\u003e\u003c/em\u003e列包含被引用目录的名称，而\u003cem class=\"parameter\"\u003e\u003ccode\u003epkcols\u003c/code\u003e\u003c/em\u003e列包含被引用列的名称。如果\u003cem class=\"parameter\"\u003e\u003ccode\u003eis_array\u003c/code\u003e\u003c/em\u003e为真，则最后一个引用列是一个数组，其每个元素都应该与被引用目录中的某个条目匹配。如果\u003cem class=\"parameter\"\u003e\u003ccode\u003eis_opt\u003c/code\u003e\u003c/em\u003e为真，则允许引用列包含零而不是有效引用。","signatures":[{"description_zh":"返回一组记录，描述存在于PostgreSQL系统目录中的外键关系。fktable 列包含引用目录的名称，fkcols列包含引用列的名称。类似地，pktable列包含被引用目录的名称，而pkcols列包含被引用列的名称。如果is_array为真，则最后一个引用列是一个数组，其每个元素都应该与被引用目录中的某个条目匹配。如果is_opt为真，则允许引用列包含零而不是有效引用。","description_zh_html":"返回一组记录，描述存在于\u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e系统目录中的外键关系。\u003cem class=\"parameter\"\u003e\u003ccode\u003efktable\u003c/code\u003e\u003c/em\u003e 列包含引用目录的名称，\u003cem class=\"parameter\"\u003e\u003ccode\u003efkcols\u003c/code\u003e\u003c/em\u003e列包含引用列的名称。类似地，\u003cem class=\"parameter\"\u003e\u003ccode\u003epktable\u003c/code\u003e\u003c/em\u003e列包含被引用目录的名称，而\u003cem class=\"parameter\"\u003e\u003ccode\u003epkcols\u003c/code\u003e\u003c/em\u003e列包含被引用列的名称。如果\u003cem class=\"parameter\"\u003e\u003ccode\u003eis_array\u003c/code\u003e\u003c/em\u003e为真，则最后一个引用列是一个数组，其每个元素都应该与被引用目录中的某个条目匹配。如果\u003cem class=\"parameter\"\u003e\u003ccode\u003eis_opt\u003c/code\u003e\u003c/em\u003e为真，则允许引用列包含零而不是有效引用。","returns":"setof record","text":"pg_get_catalog_foreign_keys () → setof record ( fktable regclass, fkcols text[], pktable regclass, pkcols text[], is_array boolean, is_opt boolean )","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"a40b76b3771add84a118b80fd1c0b751aa9d9c1648e178447b2c253a7e96daa8","Text":"pg_get_catalog_foreign_keys () → setof record ( fktable regclass, fkcols text[], pktable regclass, pkcols text[], is_array boolean, is_opt boolean )","Returns":"setof record","Payload":{"description":"Returns a set of records describing the foreign key relationships that exist within the PostgreSQL system catalogs. The fktable column contains the name of the referencing catalog, and the fkcols column contains the name(s) of the referencing column(s). Similarly, the pktable column contains the name of the referenced catalog, and the pkcols column contains the name(s) of the referenced column(s). If is_array is true, the last referencing column is an array, each of whose elements should match some entry in the referenced catalog. If is_opt is true, the referencing column(s) are allowed to contain zeroes instead of a valid reference.","description_html":"Returns a set of records describing the foreign key relationships that exist within the \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e system catalogs. The \u003cem class=\"parameter\"\u003e\u003ccode\u003efktable\u003c/code\u003e\u003c/em\u003e column contains the name of the referencing catalog, and the \u003cem class=\"parameter\"\u003e\u003ccode\u003efkcols\u003c/code\u003e\u003c/em\u003e column contains the name(s) of the referencing column(s). Similarly, the \u003cem class=\"parameter\"\u003e\u003ccode\u003epktable\u003c/code\u003e\u003c/em\u003e column contains the name of the referenced catalog, and the \u003cem class=\"parameter\"\u003e\u003ccode\u003epkcols\u003c/code\u003e\u003c/em\u003e column contains the name(s) of the referenced column(s). If \u003cem class=\"parameter\"\u003e\u003ccode\u003eis_array\u003c/code\u003e\u003c/em\u003e is true, the last referencing column is an array, each of whose elements should match some entry in the referenced catalog. If \u003cem class=\"parameter\"\u003e\u003ccode\u003eis_opt\u003c/code\u003e\u003c/em\u003e is true, the referencing column(s) are allowed to contain zeroes instead of a valid reference.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_get_catalog_foreign_keys\u003c/code\u003e () → \u003ccode class=\"returnvalue\"\u003esetof record\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003efktable\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eregclass\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003efkcols\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext[]\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003epktable\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eregclass\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003epkcols\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext[]\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eis_array\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eis_opt\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e )","returns":"setof record","text":"pg_get_catalog_foreign_keys () → setof record ( fktable regclass, fkcols text[], pktable regclass, pkcols text[], is_array boolean, is_opt boolean )","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}