pg_foreign_data_wrapper
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)
- column
- PostgreSQL 8.4
- added (commit cae565e5)
References
- PostgreSQL documentation: pg_foreign_data_wrapper