Topics: |
COPY FROM allows for very fast loading of file data in a single step. This is equivalent to LOAD DATA INFILE, for those familiar with MySQL. The COPY FROM syntax works in a manner similar to standard PostgreSQL (COPY FROM). However, there are differences in the options supported. The examples and table below outline these differences.
copy tab1 from '/tmp/data' with (format txt_variable, lines_terminated_by e'\n', delimiter ';') copy tab1 from '/tmp/data' with (format infobright) copy tab1 from '/tmp/data' with (format ib_binary) COPY table_name FROM { 'filename' | STDIN } [ [ WITH ] ( option [, ...] ) ]
where:
Can be one of the following:
PARAMETERS |
|||
---|---|---|---|
PARAMETER |
EQUIVALENT DLPPARAMETER NAME |
AVAILABLE VALUES |
DEFAULT VALUE WITH HYPERSTAGE |
format |
txt_variable infobright ib_binary |
txt_variable |
|
delimiter |
fields-terminated-by |
only a single one-byte character |
\t |
quote |
fields-enclosed-by |
only a single one-byte character |
(empty) |
escape |
escaped-by |
only a single one-byte character |
(empty) |
encoding |
data-chartset |
only supported encodings by Hyperstage |
(database encoding) *4-byte UTF-8 characters (CHAR, VARCHAR types) are replaced with question marks (?) |
lines_terminated_by |
lines-terminated-by |
(empty) |
|
reject_file_path |
reject-file-path |
(not specified) |
|
abort_on_count |
abort-on-count |
(disabled) |
|
abort_on_threshold |
abort-on-threshold |
in range (0,1) |
(disabled) |
pipe_mode |
input-type |
client server |
(not used) |
timeout |
timeout |
600s |
You must set the data format parameter. Possible values are:
WebFOCUS | |
Feedback |