华为GaussDB T 字段中有换行如何dump、load

文本数据中有换行符

create table t_test12345(xx int, yy varchar(100), zz int);

insert into t_test12345 values(1, 'abcd' || chr(10) || 'ddd', 11);

insert into t_test12345 values (2, 'abcd' || chr(10) || 'ddd', 22);

commit;

1）修改行分割符为\n*

dump table t_test12345 into file 'x1.txt' lines TERMINATED BY '\n*';

create table t_test22222(xx int, yy varchar(100), zz int);

load data infile 'x1.txt' into table t_test22222 lines TERMINATED BY '\n*';

2）使用enclosed包住数据（可以用ascii=0的异常字符）

dump table t_test12345 into file 'x2.txt' FIELDS ENCLOSED BY '\x00';

truncate table t_test22222;

load data infile 'x2.txt' into table t_test22222 FIELDS ENCLOSED BY '\x00';