> > 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'
Regards, Raghavendra EnterpriseDB Corporation Blog: http://raghavt.blogspot.com/