↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / 20devel
Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1
Historical version. PostgreSQL 11 has reached end of support. 2023-11-09. See the current manual.

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 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

NameTypeReferencesDescription
ftrelidoidpg_class.oidOID of the pg_class entry for this foreign table
ftserveroidpg_foreign_server.oidOID of the foreign server for this foreign table
ftoptionstext[]  Foreign table options, as “keyword=value” strings

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.