Postgresql 中文操作指南

53.25. pg_foreign_table #

目录 pg_foreign_table 包含有关外表的辅助信息。正如常规表一样,外表主要由 pg_class 项表示。它的 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 53.25. pg_foreign_table Columns

Table 53.25. pg_foreign_table Columns

Column Type

Description

ftrelid oid (references pg_class.oid)

The 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 “keyword=value” strings