Re: COPY from STDIN vs file with large CSVs

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: COPY from STDIN vs file with large CSVs
Дата
Msg-id CAKFQuwZSUCOc9KdzJj6xWtf+9xqpE_hA-scGEnYh8qwMYv3Xqw@mail.gmail.com
обсуждение исходный текст
Ответ на RE: COPY from STDIN vs file with large CSVs  (Indirani Venkopa Chetty <ivchetty@crosslinktax.com>)
Список pgsql-admin
On Wed, Jan 8, 2020 at 9:31 AM Indirani Venkopa Chetty <ivchetty@crosslinktax.com> wrote:

Hi Wells,

I am trying import CSV file in to Amazon RDS PostgreSQL

I am getting following error , In internal PostgreSQL it works

 



"COPY with a file name instructs the PostgreSQL server to directly read from or write to a file." -  i.e., Even had the server accepted your command it wasn't going to find your file.

Use either psql's "\copy" meta command or "COPY FROM STDIN" (search around for the needed syntax to make that work).

David J.

Вложения

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

Предыдущее
От: Wells Oliver
Дата:
Сообщение: Re: COPY from STDIN vs file with large CSVs
Следующее
От: bricklen
Дата:
Сообщение: Re: COPY from STDIN vs file with large CSVs