Product DocumentationAppearance
sys.external_format
A system view that returns information about the external format objects in the instance.
| Column Name | Data Type | Description |
|---|---|---|
| external_format_id | bigint | Unique ID of the external format object. |
| name | text | Name of the external format object. |
| owner_id | bigint | Unique ID of the user who owns the external format object. Join key for sys.user and sys.role. |
| type | text | Type of format: CSV, TEXT, or BCP, PARQUET. |
| format_options | text | JSON string that lists all of the load options that were defined for this external format object. |
| creation_time | timestamptz | When the external format object was created. |
| modify_time | timestamptz | This value is currently the same as creation_time because external format objects cannot be modified. |
Example
premdb=# select * from sys.external_format where name='premdbs3format';
-[ RECORD 1 ]------+------------------------------------------------------------------------------
external_format_id | 137328
name | premdbs3format
owner_id | 137192
type | csv
format_options | {"version":1,"type":"csv","opts":{"skip_blank_lines":"true","delimiter":","}}
creation_time | 2022-06-14 11:58:22.382366-07
modify_time | 2022-06-14 11:58:22.382366-07