A newer version of this documentation is available. Use the version menu above to view the most up-to-date release of the Greenplum 5.x documentation.


The pg_exttable system catalog table is used to track external tables and web tables created by the CREATE EXTERNAL TABLE command.

Table 1. pg_catalog.pg_exttable
column type references description
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 ON segment locations defined for the external table.
fmttype char   Format of the external table files: t for text, or c for csv.
fmtopts text   Formatting options of the external table files, such as the field delimiter, null string, escape character, etc.
options text[]   The options defined for the external table.
command text   The OS command to execute 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.
fmterrtbl oid pg_class.oid The object id of the error table where format errors will be logged.

NOTE: This column is no longer used and will be removed in a future release.

encoding text   The client encoding.
writable boolean   0 for readable external tables, 1 for writable external tables.