sys_bulkload命令:
sys_bulkload -i /home/kingbase/test3.csv -O t1 -l /home/kingbase/test3.log -o “TYPE=CSV” -o “DELIMITER=|” -USYSTEM -W12345678ab -d TEST
copy命令:
COPY (select * from test3) TO ‘/home/kingbase/test3.csv’ WITH csv;
sys_bulkload命令:
sys_bulkload -i /home/kingbase/test3.csv -O t1 -l /home/kingbase/test3.log -o “TYPE=CSV” -o “DELIMITER=|” -USYSTEM -W12345678ab -d TEST
copy命令:
COPY (select * from test3) TO ‘/home/kingbase/test3.csv’ WITH csv;