pg_foreign_data_wrapper

A system 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 added in PostgreSQL 8.4.

psql command

\dew lists foreign data wrappers.

Definition by PostgreSQL version

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)
    

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

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

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