Catalogs: pg_foreign_table

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

© 1996–2017 The PostgreSQL Global Development Group
Licensed under the PostgreSQL License.
https://www.postgresql.org/docs/9.6/static/catalog-pg-foreign-table.html

在线笔记
App下载
App下载

扫描二维码

下载编程狮App

公众号
微信公众号

编程狮公众号

意见反馈
返回顶部