[pgadmin-support] ERROR: relative path not allowed for COPY to file

2013-02-14 Thread Katona, Steve
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'

Re: [pgadmin-support] ERROR: relative path not allowed for COPY to file

2013-02-14 Thread Katona, Steve
OPY (select * from file) TO '\"C:\Dev\test.csv\"'; COPY (select * from file) TO '\"C:/Dev/test.csv\"'; Is there somewhere that I can check what is actually being passed to the shell? Or would I need to debug psql.exe? cheers Steven Ps (thanks for the s

Re: [pgadmin-support] ERROR: relative path not allowed for COPY to file

2013-02-14 Thread Katona, Steve
users" for details. Could this be contributing to my problem? Cheers Steven From: Michael Shapiro [mailto:mshapir...@gmail.com] Sent: Friday, 15 February 2013 1:48 PM To: Katona, Steve Cc: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] ERROR: relative path not allowed f

Re: [pgadmin-support] ERROR: relative path not allowed for COPY to file

2013-02-14 Thread Katona, Steve
Thanks Ilya, Everything is blindingly clear now! Thanks for your response, muchly appreciated Steven From: Ilya Makarov [mailto:makarov.t...@gmail.com] Sent: Friday, 15 February 2013 2:50 PM To: Katona, Steve Cc: Subject: Re: [pgadmin-support] ERROR: relative path not allowed for