Click here to Skip to main content
15,436,489 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I need to copy table data into text file in csv format ..how to do that?


please help me ..

What I have tried:

COPY actor TO '"D:\\book1.csv"' DELIMITER ',' CSV HEADER;


I am receving error while executing this query please tell me..that book1.csv file have to create first before copying data into that.
'
ERROR: relative path not allowed for COPY to file
********** Error **********

ERROR: relative path not allowed for COPY to file
SQL state: 42602
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900