pg_exttable

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

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.

Parent topic: System Catalogs Definitions