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

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

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

PostgreSQL 9.1
- column fdwhandler added (commit 327e0250)
PostgreSQL 8.4
- added (commit cae565e5)

References

PostgreSQL documentation: pg_foreign_data_wrapper

Version charts

Useful overviews

Useful links

Contents

pg_foreign_data_wrapper

psql command

Definition by PostgreSQL version

pg_foreign_data_wrapper (PostgreSQL 16)

pg_foreign_data_wrapper (PostgreSQL 15)

pg_foreign_data_wrapper (PostgreSQL 14)

pg_foreign_data_wrapper (PostgreSQL 13)

pg_foreign_data_wrapper (PostgreSQL 12)

pg_foreign_data_wrapper (PostgreSQL 11)

pg_foreign_data_wrapper (PostgreSQL 10)

pg_foreign_data_wrapper (PostgreSQL 9.6)

pg_foreign_data_wrapper (PostgreSQL 9.5)

pg_foreign_data_wrapper (PostgreSQL 9.4)

pg_foreign_data_wrapper (PostgreSQL 9.3)

pg_foreign_data_wrapper (PostgreSQL 9.2)

pg_foreign_data_wrapper (PostgreSQL 9.1)

pg_foreign_data_wrapper (PostgreSQL 9.0)

pg_foreign_data_wrapper (PostgreSQL 8.4)

Change history

References

Categories

See also