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'
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
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
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