{"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","derived_content_hash":"a80c29c27b5016adfbd68fc33885ed3da827ab6183114f070c700eb89cabc11c","documentation_refresh":{"batch":"20261113","original_source_rev":"wiki-repair-20261023:8d1cc57573340d992de1b74d19b22a9f7c8763ef753444bd8d330226dbc2fc58","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"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"],"repair_provenance":{"original_source_revision":"b7bd9cda","receipt_sha256":"ad82b8c813b6061d38e1911b7e8fc43b17e3d42f0a52fcf32a10faf6172b734a","repair":"wiki-repair-20261023"},"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":"wiki-repair-20261023:8d1cc57573340d992de1b74d19b22a9f7c8763ef753444bd8d330226dbc2fc58","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":"wiki-repair-20261023:8d1cc57573340d992de1b74d19b22a9f7c8763ef753444bd8d330226dbc2fc58","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":"返回一组记录，描述存在于 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 为真，则允许引用列包含零而不是有效引用。","doc":{"anchor":"FUNCTIONS-INFO-CATALOG-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 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":"返回一组记录，描述存在于 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 为真，则允许引用列包含零而不是有效引用。","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":"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-CATALOG-TABLE","file":"functions-info.html","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-get-catalog-foreign-keys","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_get_catalog_foreign_keys","Summary":"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.","BodyHTML":"Returns a set of records describing the foreign key relationships that exist within the \u003cspan\u003ePostgreSQL\u003c/span\u003e system catalogs. The \u003cem\u003e\u003ccode\u003efktable\u003c/code\u003e\u003c/em\u003e column contains the name of the referencing catalog, and the \u003cem\u003e\u003ccode\u003efkcols\u003c/code\u003e\u003c/em\u003e column contains the name(s) of the referencing column(s). Similarly, the \u003cem\u003e\u003ccode\u003epktable\u003c/code\u003e\u003c/em\u003e column contains the name of the referenced catalog, and the \u003cem\u003e\u003ccode\u003epkcols\u003c/code\u003e\u003c/em\u003e column contains the name(s) of the referenced column(s). If \u003cem\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\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.","SourceRevision":"wiki-repair-20261023:8d1cc57573340d992de1b74d19b22a9f7c8763ef753444bd8d330226dbc2fc58","ContentHash":"06e9d6a4f12c66e8e48c29e9884f4047da729bea51e041f8783c34d5ec87e4bb","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.","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":"返回一组记录，描述存在于 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 为真，则允许引用列包含零而不是有效引用。","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":"same-version-manual"}]}},"RequestedLocale":"en","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":"返回一组记录，描述存在于 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 为真，则允许引用列包含零而不是有效引用。","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":"same-version-manual"}}],"Spellings":null,"SQLState":null,"Evidence":null}