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
Hi. Is this path(”C:/Dev/test.csv") on the server with PostgreSQL database? You
can't COPY to file on the client machine.
Part from man pages (http://www.postgresql.org/docs/9.1/static/sql-copy.html):
Files named in a COPY command are read or written directly by the server, not
by the client ap
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
peedy response!)
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 for COPY
to file
It might be the /
Try \ instead
On Thu, Fe
It might be the /
Try \ instead
On Thu, Feb 14, 2013 at 8:43 PM, Katona, Steve <
skat...@begavalley.nsw.gov.au> wrote:
> 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”';
>
> ** *
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'
