PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

SYSTEM CATALOGS / SYSTEM CATALOGS

pg_foreign_data_wrapper

Read PG 18 manual ↗

The catalog pg_foreign_data_wrapper stores foreign-data wrapper definitions.

Kind: System catalogs
Columns in this snapshot: 7
Definition source: English manual

Columns 7

Column	Type	Description / reference
`oid`	`oid`	Row identifier
`fdwname`	`name`	Name of the foreign-data wrapper
`fdwowner`	`oid`	Owner of the foreign-data wrapper pg_authid.oid
`fdwhandler`	`oid`	References a handler function that is responsible for supplying execution routines for the foreign-data wrapper. Zero if no handler is provided pg_proc.oid
`fdwvalidator`	`oid`	References a validator function that is responsible for checking the validity of the options given to the foreign-data wrapper, as well as options for foreign servers and user mappings using the foreign-data wrapper. Zero if no validator is provided pg_proc.oid
`fdwacl`	`aclitem[]`	Access privileges; see Section 5.8 for details
`fdwoptions`	`text[]`	Foreign-data wrapper specific options, as “keyword=value” strings

Column history across versions

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`oid`	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`fdwname`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`fdwowner`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`fdwhandler`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`fdwvalidator`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`fdwacl`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`fdwoptions`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`fdwconnection`	·	·	·	·	·	·	·	·	·	·	·	·	·	·	·	·	●	●

Version history 6

Definition snapshot: english-manuals:7ad6657e45ff4ed909adc3fdb2c… · English manual source