From: | "Katona, Steve" <SKatona(at)begavalley(dot)nsw(dot)gov(dot)au> |
---|---|
To: | <pgadmin-support(at)postgresql(dot)org> |
Cc: | "Michael Shapiro" <mshapiro51(at)gmail(dot)com> |
Subject: | Re: ERROR: relative path not allowed for COPY to file |
Date: | 2013-02-15 03:14:56 |
Message-ID: | CFF47E56EA077241B1FFF390344B5FC10ACB1BE6@webmail.begavalley.nsw.gov.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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" for details.
Could this be contributing to my problem?
Cheers
Steven
From: Michael Shapiro [mailto:mshapiro51(at)gmail(dot)com]
Sent: Friday, 15 February 2013 1:48 PM
To: Katona, Steve
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: [pgadmin-support] ERROR: relative path not allowed for COPY
to file
It might be the /
Try \ instead
On Thu, Feb 14, 2013 at 8:43 PM, Katona, Steve
<SKatona(at)begavalley(dot)nsw(dot)gov(dot)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"';
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'"C:/Dev/exponare_data_mgr/exponare_filelist.txt"';
I get the following error:
ERROR: could not open file
""C:/Dev/exponare_data_mgr/exponare_filelist.txt"" for reading: No such
file or directory
SQL state: 58P01
I suspect that pgAdmin is not passing the filename in a manner, that the
shell on windows7 ,interprets correctly.
I have also tried the same commands from the psql console and achieve
the same results.
Under linux the commands work well.
Is there a suggestion for things I change/check to get COPY to work?
Cheers
Steven
Check out all the latest news and events at Council on
www.begavalley.nsw.gov.au <http://www.begavalley.nsw.gov.au/> .
Check out all the latest news and events at Council on http://www.begavalley.nsw.gov.au/.
_____________________________________________________________________
This e-mail has been scanned for viruses by MCI's Internet Managed
Scanning Services - powered by MessageLabs. For further information
visit http://www.mci.com
_____________________________________________________________________
This e-mail has been scanned for viruses by MCI's Internet Managed
Scanning Services - powered by MessageLabs. For further information
visit http://www.mci.com
_____________________________________________________________________
This e-mail has been scanned for viruses by MCI's Internet Managed
Scanning Services - powered by MessageLabs. For further information
visit http://www.mci.com
From | Date | Subject | |
---|---|---|---|
Next Message | Ilya Makarov | 2013-02-15 03:50:23 | Re: ERROR: relative path not allowed for COPY to file |
Previous Message | Katona, Steve | 2013-02-15 02:56:28 | Re: ERROR: relative path not allowed for COPY to file |