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.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- catalog
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- oid, fdwname, fdwowner, fdwhandler, fdwvalidator, fdwacl, fdwoptions
- runtime verified
- false
- source
- english-manual
Definition PG 18
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.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| oid | oid | Not null | Row identifier |
| fdwname | name | Not null | Name of the foreign-data wrapper |
| fdwowner | oid | Not null | Owner of the foreign-data wrapper |
| fdwhandler | oid | Not null | References a handler function that is responsible for supplying execution routines for the foreign-data wrapper. Zero if no handler is provided |
| fdwvalidator | oid | Not null | 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 validator is provided |
| fdwacl | aclitem[] | Nullable | Access privileges; see Section 5.8 for details |
| fdwoptions | text[] | Nullable | Foreign-data wrapper specific options, as “keyword=value” strings |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:18eba27f746e62d296d8276196883ac74d3837473ed94b0d926d51fcdcbeb8cb
Text language: en · catalog-bilingual-repair:18eba27f746e62d296d8276196883ac74d3837473ed94b0d926d51fcdcbeb8cb