通过标准输入输出实现Greenplum文件导入导出方法:
导出:
psql -h 192.168.0.1 -U test_user test_db -c "copy(select * from test_schema.test_table where Day_Id = '20140105' limit 2000) to STDOUT;" >/mytemp/test.txt
导入:
cat /mytemp/test.txt |psql -h 192.168.0.1 -U test_user test_db -c 'copy test_schema.test_table from stdin;'