v0.9.2 Summary Chapter 3: Database objects 3. Introduction 3.18. Foreign data wrappers

3.18. Foreign data wrappers

Foreign data wrappers are objects used to consume data from different data sources not necessarily other PostgreSQL database system. These different data sources can be CSV files, web services or even database servers from different vendors.

Attributes Description
Handler The name of a previously registered function that will be called to retrieve the execution functions for foreign tables. The handler function must take no arguments, and its return type must be fdw_handler.
Validator The name of a previously registered function that will be called to check the generic options given to the foreign data wrapper, as well as options for foreign servers, user mappings and foreign tables using the foreign data wrapper.
Options Specifies the options for the foreign data wrapper. The allowed option names and values are specific to each foreign data wrapper and are validated using the foreign data wrapper's validator function.

Mar 17, 2020 at 15:09