Re: Problem with sql COPY command

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: Problem with sql COPY command
Дата
Msg-id 873c28xm8n.fsf@asmodeus.mcnaught.org
обсуждение исходный текст
Ответ на Problem with sql COPY command  ("Jon Asher" <jon@vagabond-software.com>)
Список pgsql-general
"Jon Asher" <jon@vagabond-software.com> writes:

>    A comma delimited text file has been placed in a local directory with
>    permissions set to allow any user to read or write to it:
>    /root/Desktop/server_transfer/WorldPoints_v2.txt'

The '/root' directory is often not world-readable.  Try putting the
file under '/tmp' or '/var/tmp', and remember that the file will be
read as the "postgres" user (or whatever your database server runs
as).

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863

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

Предыдущее
От: Thomas F.O'Connell
Дата:
Сообщение: Re: pg_autovacuum start-script
Следующее
От: Richard Poole
Дата:
Сообщение: Re: Problem with sql COPY command