47.24. pg_foreign_table

This catalog exists in each coordinator and datanode in Postgres-XC as inherited from PostgreSQL. Please note that current release of Postgres-XC does not support foreign data wrapper.

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 47-24. 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