• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PG_FOREIGN_TABLE

PG_FOREIGN_TABLE

PG_FOREIGN_TABLE stores auxiliary information about foreign tables.

Table 1 PG_FOREIGN_TABLE columns

Name

Type

Description

ftrelid

oid

ID of the foreign table

ftserver

oid

Server where the foreign table is located

ftwriteonly

Boolean

Whether data can be written in the foreign table

ftoptions

text[]

Foreign table option