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 C
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
Hi,
I have noticed that I receive a warning when opening a psql console from
pgAdmin III.
Console code page (850) differs from Windows code page
(1252)
8-bit characters might not work correctly. See psql
reference
Page "Notes for Windows users" fo
Hi,
Here are the variations of slashes, sloshes and speech marks which have
achieved the same (failed) outcome:
COPY (select * from file) TO '"C:\\Dev\\test.csv"';
COPY (select * from file) TO '"C:\Dev\test.csv"';
COPY (select * from file) TO '"C:/Dev/test.csv"';
COPY (select * from file
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'
Pgadmin crashes on me a lot because the connection to the db has been severed
by the network for inactivity.
Often, I've been working on a query and have not yet saved the query.
Is there any place the active queries are cached on disk that I might be able
to recover from?
Thanks
Doug Little
