pg_foreign_table
The system catalog table 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.
| Column | Type | References | Description |
|---|---|---|---|
ftrelid |
oid |
pg_class.oid |
OID of the |
ftserver |
oid |
pg_foreign_server.oid |
OID of the foreign server for this foreign table |
ftoptions |
text[] |
— |
Foreign table options, as |