pg_foreign_data_wrapper

The pg_foreign_data_wrapper catalog provides information about foreign-data wrapper definitions.

Column name Data type Description
oid oid A row identifier.
fdwname name The name of the foreign-data wrapper.
fdwowner oid (references pg_authid.oid) The OID of the role that owns the foreign-data wrapper.
fdwhandler oid (references pg_proc.oid) The OID of the handler function that provides execution routines for the foreign-data wrapper.
0 – No handler provided.
fdwvalidator oid (references pg_proc.oid) The OID of the validator function that checks the validity of options for the foreign-data wrapper, as well as for foreign servers and user mappings.
0 – No validator provided.
fdwacl aclitem[] Access privileges for the foreign-data wrapper.
fdwoptions text[] Foreign-data wrapper–specific options as “keyword=value” strings.