PostgreSQL

51.25. `pg_foreign_table`
Prev	Up	Chapter 51. System Catalogs	Home	Next

51.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 51.25. pg_foreign_table Columns

Column Type Description

Column Type Description
`ftrelid` `oid` (references `pg_class`.`oid`) OID of the `pg_class` entry for this foreign table
`ftserver` `oid` (references `pg_foreign_server`.`oid`) OID of the foreign server for this foreign table
`ftoptions` `text[]` Foreign table options, as “[.quote]#keyword=value”# strings

ftrelid oid (references pg_class.oid)

OID of the pg_class entry for this foreign table

ftserver oid (references pg_foreign_server.oid)

OID of the foreign server for this foreign table

ftoptions text[]

Foreign table options, as “[.quote]#keyword=value”# strings

Prev	Up	Next
51.24. `pg_foreign_server`	Home	51.26. `pg_index`

51.24. pg_foreign_server

Home

51.26. pg_index

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

PostgreSQL

51.25. pg_foreign_table

Submit correction

51.25. `pg_foreign_table`