PG_FOREIGN_DATA_WRAPPER

Updated on 2024-09-30 GMT+08:00

View PDF

PG_FOREIGN_DATA_WRAPPER records foreign-data wrapper definitions. A foreign-data wrapper is the mechanism by which external data, residing on foreign servers, is accessed.

**Table 1** PG_FOREIGN_DATA_WRAPPER columns
Name	Type	Reference	Description
oid	oid	N/A	Row identifier (hidden attribute; displayed only when explicitly selected)
fdwname	name	N/A	Name of the foreign-data wrapper
fdwowner	oid	PG_AUTHID.oid	Owner of the foreign-data wrapper
fdwhandler	oid	PG_PROC.oid	References a handler function that is responsible for supplying execution routines for the foreign-data wrapper. Its value is 0 if no handler is provided.
fdwvalidator	oid	PG_PROC.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. Its value is 0 if no validator is provided.
fdwacl	aclitem[]	N/A	Access permissions
fdwoptions	text[]	N/A	Option used for foreign data wrappers. It is a keyword=value string.