|
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 |