COPY (select id as ID, description as TNAME from my_table order by id) to ‘C:/exp4analyze/MyTable.csv’ with csv header;
ERROR: could not open file “C:/exp4analyze/MyTable.csv” for writing: No such file or directory
原因:目录不存在
COPY (select id as ID, description as TNAME from my_table order by id) to ‘C:/exp4analyze/MyTable.csv’ with csv header;
ERROR: could not open file “C:/Users/exp4analyze/MyTable.csv” for writing: Permission denied
原因:不能将导出路径放在系统文件夹下(C盘其他文件夹可以)
COPY (select id as ID, description as TNAME from my_table order by id) to ‘D:/exp4analyze/MyTable.csv’ with csv header;
Query returned successfully: 279 rows affected, 12 msec execution time.
正确结果
PS:如果出现 Invalid Argument 错误,考虑是“命令行”窗口或“pgAdmin”工具缺少管理员权限的原因。