| Postgres-XC 1.2 Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Chapter 47. System Catalogs | Fast Forward | Next |
This catalog exists in each coordinator and datanode in Postgres-XC as inheritted from PostgreSQL. Please note that current release of Postgres-XC does not support foreign data wrapper.
Note: The following description applies both to Postgres-XC and PostgreSQL if not described explicitly. You can read PostgreSQL as Postgres-XC except for version number, which is specific to each product.
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-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 |