50.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 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 50-25. pg_foreign_table Columns
| Name | Type | References | Description |
|---|---|---|---|
ftrelid | oid | pg_class.oid | OID of the pg_class entry for this foreign table |
ftserver | oid | pg_foreign_server.oid | OID of the foreign server for this foreign table |
ftoptions | text[] | Foreign table options, as "keyword=value" strings |
© 1996–2019 The PostgreSQL Global Development Group
Licensed under the PostgreSQL License.
https://www.postgresql.org/docs/9.6/catalog-pg-foreign-table.html