Help Center > > Developer Guide> System Catalogs and System Views> System Catalogs> PG_FOREIGN_DATA_WRAPPER

PG_FOREIGN_DATA_WRAPPER

Updated at: May 15, 2019 GMT+08:00

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

-

Row identifier (hidden attribute, must be specified)

fdwname

name

-

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. Zero 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. Zero if no handler is provided

fdwacl

aclitem[]

-

Access permissions

fdwoptions

text[]

-

Option used for foreign data wrappers. It is a keyword=value string.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel