目录

pg_get_catalog_foreign_keys()

一个用于列出系统目录外键的函数

pg_get_catalog_foreign_keys() 是一个系统函数，它返回一个 系统目录 伪 外键 关系的列表。

pg_get_catalog_foreign_keys() 在 PostgreSQL 14 中被添加。

用法

pg_get_catalog_foreign_keys () →
          setof record ( fktable regclass,
                         fkcols text[],
                         pktable regclass,
                         pkcols text[],
                         is_array boolean,
                         is_opt boolean )

变更历史

示例

pg_get_catalog_foreign_keys() 内容示例

postgres=# SELECT *
             FROM pg_get_catalog_foreign_keys()
            WHERE fktable = 'pg_class'::regclass;
 fktable  |     fkcols      |    pktable    | pkcols | is_array | is_opt 
----------+-----------------+---------------+--------+----------+--------
 pg_class | {relnamespace}  | pg_namespace  | {oid}  | f        | f
 pg_class | {reltype}       | pg_type       | {oid}  | f        | t
 pg_class | {reloftype}     | pg_type       | {oid}  | f        | t
 pg_class | {relowner}      | pg_authid     | {oid}  | f        | f
 pg_class | {relam}         | pg_am         | {oid}  | f        | t
 pg_class | {reltablespace} | pg_tablespace | {oid}  | f        | t
 pg_class | {reltoastrelid} | pg_class      | {oid}  | f        | t
 pg_class | {relrewrite}    | pg_class      | {oid}  | f        | t
(8 rows)

分类

系统目录, 系统函数

反馈

请在此处提交关于 "pg_get_catalog_foreign_keys()" 的任何评论、建议或更正 。