I am using pgAdmin 14.1 and then tried with pgAdmin 16.1 I have tried: COPY (select * from file) TO '”C:/Dev/test.csv”'; And get the error: ERROR: relative path not allowed for COPY to file SQL state: 42602 Also, when I try: COPY temp_import FROM E'"C:/Dev/exponare_data_mgr/exponare_filelist.txt"';I get the following error:ERROR: could not open file ""C:/Dev/exponare_data_mgr/exponare_filelist.txt"" for reading: No such file or directorySQL state: 58P01 I suspect that pgAdmin is not passing the filename in a manner, that the shell on windows7 ,interprets correctly.I have also tried the same commands from the psql console and achieve the same results. Under linux the commands work well.Is there a suggestion for things I change/check to get COPY to work?CheersSteven Check out all the latest news and events at Council on www.begavalley.nsw.gov.au. _____________________________________________________________________ This e-mail has been scanned for viruses by MCI's Internet Managed Scanning Services - powered by MessageLabs. For further information visit http://www.mci.com
I am using pgAdmin 14.1 and then tried with pgAdmin 16.1
I have tried:
COPY (select * from file) TO '”C:/Dev/test.csv”';
And get the error:
ERROR: relative path not allowed for COPY to file
SQL state: 42602
Also, when I try:
COPY temp_import FROM E'"C:/Dev/exponare_data_mgr/exponare_filelist.txt"';
I get the following error:
ERROR: could not open file ""C:/Dev/exponare_data_mgr/exponare_filelist.txt"" for reading: No such file or directory
SQL state: 58P01
I suspect that pgAdmin is not passing the filename in a manner, that the shell on windows7 ,interprets correctly.
I have also tried the same commands from the psql console and achieve the same results.
Under linux the commands work well.
Is there a suggestion for things I change/check to get COPY to work?
Cheers
Steven
pgadmin-support by date:
Соглашаюсь с условиями обработки персональных данных