目录

pg_foreign_data_wrapper

存储外部数据包装器定义的系统表

pg_foreign_data_wrapper 是一个 系统目录 表，用于存储 外部数据包装器 的定义。

pg_foreign_data_wrapper 在 PostgreSQL 8.4 中被添加。

psql 命令

\dew 列出外部数据包装器。

按 PostgreSQL 版本定义

pg_foreign_data_wrapper (PostgreSQL 19)

        Table "pg_catalog.pg_foreign_data_wrapper"
    Column    |   Type    | Collation | Nullable | Default 
--------------+-----------+-----------+----------+---------
 oid          | oid       |           | not null | 
 fdwname      | name      |           | not null | 
 fdwowner     | oid       |           | not null | 
 fdwhandler   | oid       |           | not null | 
 fdwvalidator | oid       |           | not null | 
 fdwacl       | aclitem[] |           |          | 
 fdwoptions   | text[]    | C         |          | 
Indexes:
    "pg_foreign_data_wrapper_oid_index" PRIMARY KEY, btree (oid)
    "pg_foreign_data_wrapper_name_index" UNIQUE CONSTRAINT, btree (fdwname)

文档：pg_foreign_data_wrapper

pg_foreign_data_wrapper (PostgreSQL 18)

        Table "pg_catalog.pg_foreign_data_wrapper"
    Column    |   Type    | Collation | Nullable | Default 
--------------+-----------+-----------+----------+---------
 oid          | oid       |           | not null | 
 fdwname      | name      |           | not null | 
 fdwowner     | oid       |           | not null | 
 fdwhandler   | oid       |           | not null | 
 fdwvalidator | oid       |           | not null | 
 fdwacl       | aclitem[] |           |          | 
 fdwoptions   | text[]    | C         |          | 
Indexes:
    "pg_foreign_data_wrapper_oid_index" PRIMARY KEY, btree (oid)
    "pg_foreign_data_wrapper_name_index" UNIQUE CONSTRAINT, btree (fdwname)

文档：pg_foreign_data_wrapper

pg_foreign_data_wrapper (PostgreSQL 17)

        Table "pg_catalog.pg_foreign_data_wrapper"
    Column    |   Type    | Collation | Nullable | Default 
--------------+-----------+-----------+----------+---------
 oid          | oid       |           | not null | 
 fdwname      | name      |           | not null | 
 fdwowner     | oid       |           | not null | 
 fdwhandler   | oid       |           | not null | 
 fdwvalidator | oid       |           | not null | 
 fdwacl       | aclitem[] |           |          | 
 fdwoptions   | text[]    | C         |          | 
Indexes:
    "pg_foreign_data_wrapper_oid_index" PRIMARY KEY, btree (oid)
    "pg_foreign_data_wrapper_name_index" UNIQUE CONSTRAINT, btree (fdwname)

文档：pg_foreign_data_wrapper

pg_foreign_data_wrapper (PostgreSQL 16)

        Table "pg_catalog.pg_foreign_data_wrapper"
    Column    |   Type    | Collation | Nullable | Default 
--------------+-----------+-----------+----------+---------
 oid          | oid       |           | not null | 
 fdwname      | name      |           | not null | 
 fdwowner     | oid       |           | not null | 
 fdwhandler   | oid       |           | not null | 
 fdwvalidator | oid       |           | not null | 
 fdwacl       | aclitem[] |           |          | 
 fdwoptions   | text[]    | C         |          | 
Indexes:
    "pg_foreign_data_wrapper_oid_index" PRIMARY KEY, btree (oid)
    "pg_foreign_data_wrapper_name_index" UNIQUE CONSTRAINT, btree (fdwname)

文档：pg_foreign_data_wrapper

pg_foreign_data_wrapper (PostgreSQL 15)

        Table "pg_catalog.pg_foreign_data_wrapper"
    Column    |   Type    | Collation | Nullable | Default 
--------------+-----------+-----------+----------+---------
 oid          | oid       |           | not null | 
 fdwname      | name      |           | not null | 
 fdwowner     | oid       |           | not null | 
 fdwhandler   | oid       |           | not null | 
 fdwvalidator | oid       |           | not null | 
 fdwacl       | aclitem[] |           |          | 
 fdwoptions   | text[]    | C         |          | 
Indexes:
    "pg_foreign_data_wrapper_oid_index" PRIMARY KEY, btree (oid)
    "pg_foreign_data_wrapper_name_index" UNIQUE CONSTRAINT, btree (fdwname)

文档：pg_foreign_data_wrapper

pg_foreign_data_wrapper (PostgreSQL 14)

        Table "pg_catalog.pg_foreign_data_wrapper"
    Column    |   Type    | Collation | Nullable | Default 
--------------+-----------+-----------+----------+---------
 oid          | oid       |           | not null | 
 fdwname      | name      |           | not null | 
 fdwowner     | oid       |           | not null | 
 fdwhandler   | oid       |           | not null | 
 fdwvalidator | oid       |           | not null | 
 fdwacl       | aclitem[] |           |          | 
 fdwoptions   | text[]    | C         |          | 
Indexes:
    "pg_foreign_data_wrapper_oid_index" PRIMARY KEY, btree (oid)
    "pg_foreign_data_wrapper_name_index" UNIQUE CONSTRAINT, btree (fdwname)

文档：pg_foreign_data_wrapper

pg_foreign_data_wrapper (PostgreSQL 13)

        Table "pg_catalog.pg_foreign_data_wrapper"
    Column    |   Type    | Collation | Nullable | Default 
--------------+-----------+-----------+----------+---------
 oid          | oid       |           | not null | 
 fdwname      | name      |           | not null | 
 fdwowner     | oid       |           | not null | 
 fdwhandler   | oid       |           | not null | 
 fdwvalidator | oid       |           | not null | 
 fdwacl       | aclitem[] |           |          | 
 fdwoptions   | text[]    | C         |          | 
Indexes:
    "pg_foreign_data_wrapper_name_index" UNIQUE, btree (fdwname)
    "pg_foreign_data_wrapper_oid_index" UNIQUE, btree (oid)

文档：pg_foreign_data_wrapper

pg_foreign_data_wrapper (PostgreSQL 12)

        Table "pg_catalog.pg_foreign_data_wrapper"
    Column    |   Type    | Collation | Nullable | Default 
--------------+-----------+-----------+----------+---------
 oid          | oid       |           | not null | 
 fdwname      | name      |           | not null | 
 fdwowner     | oid       |           | not null | 
 fdwhandler   | oid       |           | not null | 
 fdwvalidator | oid       |           | not null | 
 fdwacl       | aclitem[] |           |          | 
 fdwoptions   | text[]    | C         |          | 
Indexes:
    "pg_foreign_data_wrapper_name_index" UNIQUE, btree (fdwname)
    "pg_foreign_data_wrapper_oid_index" UNIQUE, btree (oid)

文档：pg_foreign_data_wrapper

pg_foreign_data_wrapper (PostgreSQL 11)

        Table "pg_catalog.pg_foreign_data_wrapper"
    Column    |   Type    | Collation | Nullable | Default 
--------------+-----------+-----------+----------+---------
 fdwname      | name      |           | not null | 
 fdwowner     | oid       |           | not null | 
 fdwhandler   | oid       |           | not null | 
 fdwvalidator | oid       |           | not null | 
 fdwacl       | aclitem[] |           |          | 
 fdwoptions   | text[]    |           |          | 
Indexes:
    "pg_foreign_data_wrapper_name_index" UNIQUE, btree (fdwname)
    "pg_foreign_data_wrapper_oid_index" UNIQUE, btree (oid)

文档：pg_foreign_data_wrapper

pg_foreign_data_wrapper (PostgreSQL 10)

        Table "pg_catalog.pg_foreign_data_wrapper"
    Column    |   Type    | Collation | Nullable | Default 
--------------+-----------+-----------+----------+---------
 fdwname      | name      |           | not null | 
 fdwowner     | oid       |           | not null | 
 fdwhandler   | oid       |           | not null | 
 fdwvalidator | oid       |           | not null | 
 fdwacl       | aclitem[] |           |          | 
 fdwoptions   | text[]    |           |          | 
Indexes:
    "pg_foreign_data_wrapper_name_index" UNIQUE, btree (fdwname)
    "pg_foreign_data_wrapper_oid_index" UNIQUE, btree (oid)

文档：pg_foreign_data_wrapper

pg_foreign_data_wrapper (PostgreSQL 9.6)

Table "pg_catalog.pg_foreign_data_wrapper"
    Column    |   Type    | Modifiers 
--------------+-----------+-----------
 fdwname      | name      | not null
 fdwowner     | oid       | not null
 fdwhandler   | oid       | not null
 fdwvalidator | oid       | not null
 fdwacl       | aclitem[] | 
 fdwoptions   | text[]    | 
Indexes:
    "pg_foreign_data_wrapper_name_index" UNIQUE, btree (fdwname)
    "pg_foreign_data_wrapper_oid_index" UNIQUE, btree (oid)

文档：pg_foreign_data_wrapper

pg_foreign_data_wrapper (PostgreSQL 9.5)

Table "pg_catalog.pg_foreign_data_wrapper"
    Column    |   Type    | Modifiers 
--------------+-----------+-----------
 fdwname      | name      | not null
 fdwowner     | oid       | not null
 fdwhandler   | oid       | not null
 fdwvalidator | oid       | not null
 fdwacl       | aclitem[] | 
 fdwoptions   | text[]    | 
Indexes:
    "pg_foreign_data_wrapper_name_index" UNIQUE, btree (fdwname)
    "pg_foreign_data_wrapper_oid_index" UNIQUE, btree (oid)

文档：pg_foreign_data_wrapper

pg_foreign_data_wrapper (PostgreSQL 9.4)

Table "pg_catalog.pg_foreign_data_wrapper"
    Column    |   Type    | Modifiers 
--------------+-----------+-----------
 fdwname      | name      | not null
 fdwowner     | oid       | not null
 fdwhandler   | oid       | not null
 fdwvalidator | oid       | not null
 fdwacl       | aclitem[] | 
 fdwoptions   | text[]    | 
Indexes:
    "pg_foreign_data_wrapper_name_index" UNIQUE, btree (fdwname)
    "pg_foreign_data_wrapper_oid_index" UNIQUE, btree (oid)

文档：pg_foreign_data_wrapper

pg_foreign_data_wrapper (PostgreSQL 9.3)

Table "pg_catalog.pg_foreign_data_wrapper"
    Column    |   Type    | Modifiers 
--------------+-----------+-----------
 fdwname      | name      | not null
 fdwowner     | oid       | not null
 fdwhandler   | oid       | not null
 fdwvalidator | oid       | not null
 fdwacl       | aclitem[] | 
 fdwoptions   | text[]    | 
Indexes:
    "pg_foreign_data_wrapper_name_index" UNIQUE, btree (fdwname)
    "pg_foreign_data_wrapper_oid_index" UNIQUE, btree (oid)

文档：pg_foreign_data_wrapper

pg_foreign_data_wrapper (PostgreSQL 9.2)

Table "pg_catalog.pg_foreign_data_wrapper"
    Column    |   Type    | Modifiers 
--------------+-----------+-----------
 fdwname      | name      | not null
 fdwowner     | oid       | not null
 fdwhandler   | oid       | not null
 fdwvalidator | oid       | not null
 fdwacl       | aclitem[] | 
 fdwoptions   | text[]    | 
Indexes:
    "pg_foreign_data_wrapper_name_index" UNIQUE, btree (fdwname)
    "pg_foreign_data_wrapper_oid_index" UNIQUE, btree (oid)

文档：pg_foreign_data_wrapper

pg_foreign_data_wrapper (PostgreSQL 9.1)

Table "pg_catalog.pg_foreign_data_wrapper"
    Column    |   Type    | Modifiers 
--------------+-----------+-----------
 fdwname      | name      | not null
 fdwowner     | oid       | not null
 fdwhandler   | oid       | not null
 fdwvalidator | oid       | not null
 fdwacl       | aclitem[] | 
 fdwoptions   | text[]    | 
Indexes:
    "pg_foreign_data_wrapper_name_index" UNIQUE, btree (fdwname)
    "pg_foreign_data_wrapper_oid_index" UNIQUE, btree (oid)

文档：pg_foreign_data_wrapper

pg_foreign_data_wrapper (PostgreSQL 9.0)

Table "pg_catalog.pg_foreign_data_wrapper"
    Column    |   Type    | Modifiers 
--------------+-----------+-----------
 fdwname      | name      | not null
 fdwowner     | oid       | not null
 fdwvalidator | oid       | not null
 fdwacl       | aclitem[] | 
 fdwoptions   | text[]    | 
Indexes:
    "pg_foreign_data_wrapper_name_index" UNIQUE, btree (fdwname)
    "pg_foreign_data_wrapper_oid_index" UNIQUE, btree (oid)

文档：pg_foreign_data_wrapper

pg_foreign_data_wrapper (PostgreSQL 8.4)

Table "pg_catalog.pg_foreign_data_wrapper"
    Column    |   Type    | Modifiers 
--------------+-----------+-----------
 fdwname      | name      | not null
 fdwowner     | oid       | not null
 fdwvalidator | oid       | not null
 fdwacl       | aclitem[] | 
 fdwoptions   | text[]    | 
Indexes:
    "pg_foreign_data_wrapper_name_index" UNIQUE, btree (fdwname)
    "pg_foreign_data_wrapper_oid_index" UNIQUE, btree (oid)

文档：pg_foreign_data_wrapper

变更历史

分类

外部数据包装器 (FDW), 系统目录

另请参阅

ALTER FOREIGN DATA WRAPPER, CREATE FOREIGN DATA WRAPPER, DROP FOREIGN DATA WRAPPER, pg_foreign_server

反馈

如有关于“pg_foreign_data_wrapper”的评论、建议或更正，请在此 提交。