pg_foreign_table
The catalog pg_foreign_table contains auxiliary information about foreign tables. A foreign table is primarily represented by a pg_class entry, just like a regular table. Its pg_foreign_table entry contains the information that is pertinent only to foreign tables and not any other kind of relation.
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
- ftrelid, ftserver, ftoptions
- runtime verified
- false
- source
- english-manual
Definition PG 18
The catalog pg_foreign_table contains auxiliary information about foreign tables. A foreign table is primarily represented by a pg_class entry, just like a regular table. Its pg_foreign_table entry contains the information that is pertinent only to foreign tables and not any other kind of relation.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| ftrelid | oid | Not null | The OID of the pg_class entry for this foreign table |
| ftserver | oid | Not null | OID of the foreign server for this foreign table |
| ftoptions | text[] | Nullable | Foreign table options, as “keyword=value” strings |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:71d4015e3f0dfbffef90916bf043f315121eeb2434b891b2de2b9db88d8e0c89
Text language: en · catalog-bilingual-repair:71d4015e3f0dfbffef90916bf043f315121eeb2434b891b2de2b9db88d8e0c89