PG_FOREIGN_TABLE

PG_FOREIGN_TABLE records auxiliary information about foreign tables.

Table 1 PG_FOREIGN_TABLE columns

Name

Type

Description

ftrelid

oid

ID of a foreign table

ftserver

oid

Server where a foreign table is located

ftwriteonly

Boolean

Specifies whether data can be written in a foreign table. Value range:

  • t (true): yes
  • f (false): no

ftoptions

text[]

Options of a foreign table. For details, see the description of CREATE FOREIGN TABLE.

Feedback
编组 3备份
    openGauss 2024-11-22 00:52:56
    cancel