catalog-pg-foreign-table.md 1.2 KB
Newer Older
K
KyleZhang 已提交
1 2 3 4 5 6 7 8 9 10 11 12 13 14
## 52.25. `pg_foreign_table`

[]()

 The catalog `pg_foreign_table` contains auxiliary information about foreign tables. A foreign table is primarily represented by a [`pg_class`](catalog-pg-class.html) 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.

**Table 52.25. `pg_foreign_table` Columns**

|                                                                Column Type<br/><br/> Description                                                               |
|----------------------------------------------------------------------------------------------------------------------------------------------------------------|
|`ftrelid` `oid` (references [`pg_class`](catalog-pg-class.html).`oid`)<br/><br/> The OID of the [`pg_class`](catalog-pg-class.html) entry for this foreign table|
|      `ftserver` `oid` (references [`pg_foreign_server`](catalog-pg-foreign-server.html).`oid`)<br/><br/> OID of the foreign server for this foreign table      |
|                                        `ftoptions` `text[]`<br/><br/> Foreign table options, as “keyword=value” strings                                        |