COMMAND: copy (select * from employee) to 'C:/emp.csv' ERROR: could not open file "C:/emp.csv" for writing: Permission denied ********** Error ********** ERROR: could not open file "C:/emp.csv" for writing: Permission denied SQL state: 42501
COMMAND: \copy (select * from employee) to 'C:/emp.csv' ERROR: syntax error at or near "\" LINE 1: \copy (select * from employee) to 'C:/emp.csv' ^ ********** Error ********** ERROR: syntax error at or near "\" SQL state: 42601
Please correct me where I am going wrong. FYI, I am running under the administrator accounts of both Windows Login and PostgreSQL.
Two things,
1. you need to have a proper permissions where the .csv file creating.
2. In windows you need to use as below
postgres=#\copy (select * from employee) to 'C:\\emp.sql'
