ERROR: relative path not allowed for COPY to file

Поиск
Список
Период
Сортировка
От Katona, Steve
Тема ERROR: relative path not allowed for COPY to file
Дата
Msg-id CFF47E56EA077241B1FFF390344B5FC10ACB1BC0@webmail.begavalley.nsw.gov.au
обсуждение исходный текст
Ответы Re: ERROR: relative path not allowed for COPY to file  (Michael Shapiro <mshapiro51@gmail.com>)
Re: ERROR: relative path not allowed for COPY to file  (Ilya Makarov <makarov.tula@gmail.com>)
Список pgadmin-support

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.
 

_____________________________________________________________________
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

В списке pgadmin-support по дате отправления:

Предыдущее
От: "Little, Douglas"
Дата:
Сообщение: query saved during crash
Следующее
От: Michael Shapiro
Дата:
Сообщение: Re: ERROR: relative path not allowed for COPY to file