长时间不用,命令都忘了,悲剧ing....
1、\copy "hotel_manu_list"("name","hotel") from
'/home/user/hotel_manu_list_utf8.csv' DELIMITERS ',' CSV;
备注:文件要用utf-8格式
附:conv -f gbk -t utf-8
hotel_manu_list.csv -o hotel_manu_list_utf8.csv
2、把sql结构导出为文件
psql [database] -c "COPY (SELECT * FROM [table]) TO STDOUT CSV HEADER" > output_file.csv