| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Indirani Venkopa Chetty <ivchetty(at)crosslinktax(dot)com> |
| Cc: | Wells Oliver <wells(dot)oliver(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: COPY from STDIN vs file with large CSVs |
| Date: | 2020-01-08 18:33:51 |
| Message-ID: | CAKFQuwZSUCOc9KdzJj6xWtf+9xqpE_hA-scGEnYh8qwMYv3Xqw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, Jan 8, 2020 at 9:31 AM Indirani Venkopa Chetty <
ivchetty(at)crosslinktax(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | bricklen | 2020-01-08 20:24:17 | Re: COPY from STDIN vs file with large CSVs |
| Previous Message | Wells Oliver | 2020-01-08 17:50:14 | Re: COPY from STDIN vs file with large CSVs |