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
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'
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”';
>
> ** *
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
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. 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
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
