pg_bulkload

pg_bulkload --help
gsql -p 5432 postgres -r

CREATE EXTENSION pg_bulkload;
create table test_bulkload(id int, name varchar(128));

seq 100000| awk '{print $0"|bulkload"}' > bulkload_output.txt

pg_bulkload -i ./bulkload_output.txt -O test_bulkload -l test_bulkload.log -p 5432 -o "TYPE=csv" -o "DELIMITER=|" -d postgres -U hlv

select count(1) from test_bulkload;

INPUT=/vdb/MogDB-server/dest/bulkload_output.txt
LOGFILE = /vdb/MogDB-server/dest/test_bulkload.log
LIMIT = INFINITE
PARSE_ERRORS = 0
CHECK_CONSTRAINTS = NO
TYPE = CSV
SKIP = 5  (该参数设置跳过几行)
DELIMITER = |
QUOTE = "\""
ESCAPE = "\""
OUTPUT = test_bulkload
MULTI_PROCESS = NO
WRITER = DIRECT
DUPLICATE_ERRORS = 0
ON_DUPLICATE_KEEP = NEW
TRUNCATE = YES

pg_bulkload ./lottu.ctl -d postgres -U hlv