September 26, 2024: PostgreSQL 17 Released!
Supported Versions: Current (17) / 16 / 15 / 14 / 13 / 12
Development Versions: devel
Unsupported versions: 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

45.20. pg_foreign_data_wrapper

The catalog pg_foreign_data_wrapper stores foreign-data wrapper definitions. A foreign-data wrapper is the mechanism by which external data, residing on foreign servers, is accessed.

Table 45-20. pg_foreign_data_wrapper Columns

Name Type References Description
fdwname name   Name of the foreign-data wrapper
fdwowner oid pg_authid.oid Owner of the foreign-data wrapper
fdwvalidator oid pg_proc.oid References a validator function that is responsible for checking the validity of the generic options given to the foreign-data wrapper, as well as to foreign servers and user mappings using the foreign-data wrapper. Zero if no validator is provided.
fdwacl aclitem[]   Access privileges; see GRANT and REVOKE for details
fdwoptions text[]   Foreign-data wrapper specific options, as "keyword=value" strings