导出语句 导出为csv格式的数据:
添加字段头导出
psql -d databasename -h localhost -p 5432 -c "\copy (select * from tablename limit 10000 ) to /tmp/my_data2.csv with csv header delimiter '|' "
不添加字段头导出
psql -d databasename -h localhost -p 5432 -c "\copy (select * from tablename limit 10000 ) to /tmp/my_data2.csv with csv delimiter '|' "
导入语句
注意:若导入的是csv格式的数据,需要删除导入文档中第一行字段的数据。
psql -h localhost -p 5432 -d databasename -U gpadmin -c "\\copy tablename FROM '/tmp/my_data.csv' with DELIMITER as '|' NULL as 'null string'"