pg_exttable

reloid

oid

pg_class.oid

The OID of this external table

urilocation

text[]

 — 

The URI location(s) of the external table files

execlocation

text[]

 — 

The segment locations defined for the external table

fmttype

char

 — 

Format of the external table files: t for text, c for CSV, b for binary

fmtopts

text

 — 

Formatting options of the external table files, such as the field delimiter, null string, escape character, and so on

options

text[]

 — 

The options defined for the external table

command

text

 — 

The OS command to run when the external table is accessed

rejectlimit

integer

 — 

The per segment reject limit for rows with errors, after which the load will fail

rejectlimittype

char

 — 

Type of reject limit threshold: r for number of rows, p for percentage of total rows

logerrors

boolean

 — 

t to log errors, f to not

encoding

integer

 — 

The client encoding

writable

boolean

 — 

f for readable external tables, t for writable external tables