Updated on 2023-10-31 GMT+08:00

PG_FOREIGN_TABLE

PG_FOREIGN_TABLE records auxiliary information about foreign tables.

Table 1 PG_FOREIGN_TABLE columns

Name

Type

Description

ftrelid

oid

OID of the foreign table

ftserver

oid

OID of the server where the foreign table is located

ftwriteonly

boolean

Whether data can be written in the foreign table

ftoptions

text[]

Foreign table options