Contents

pg_foreign_data_wrapper

A system catalogue table storing foreign data wrapper definitions

pg_foreign_data_wrapper is a system catalogue table storing foreign data wrapper definitions

pg_foreign_data_wrapper was introduced in PostgreSQL 8.4 (commit cae565e5).

psql command

\dew lists foreign data wrappers.

Definition by PostgreSQL version

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)

Documentation: 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)

Documentation: 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)

Documentation: 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)

Documentation: 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)

Documentation: 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)

Documentation: 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)

Documentation: 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)

Documentation: 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)

Documentation: 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)

Documentation: 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)

Documentation: 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)

Documentation: pg_foreign_data_wrapper

Change history

Categories

Foreign Data Wrapper (FDW), System catalogue

See also

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