Postgres Pro
Downloads
Home   >   mailing lists

Re: COPY from STDIN vs file with large CSVs - Mailing list pgsql-admin

From David G. Johnston
Subject Re: COPY from STDIN vs file with large CSVs
Date
Msg-id CAKFQuwZSUCOc9KdzJj6xWtf+9xqpE_hA-scGEnYh8qwMYv3Xqw@mail.gmail.com
Whole thread Raw
In response to RE: COPY from STDIN vs file with large CSVs  (Indirani Venkopa Chetty <ivchetty@crosslinktax.com>)
List pgsql-admin
Tree view
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

 


https://www.postgresql.org/docs/12/sql-copy.html

"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.

Attachment

pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Re: COPY from STDIN vs file with large CSVs
Next
From: bricklen
Date:
Subject: Re: COPY from STDIN vs file with large CSVs