Error import from .csv to table - Postgres - AWS-RDS

Question

Error when importing csv file to postgres database in AWS RDS:

Code:

COPY public."tableTest" FROM 'C:\Temp\tableTest.csv' DELIMITER ';' CSV HEADER ENCODING 'LATIN1';

Erro:

If I try to import it into my postgres on my desktop, it works. The error only happens in RDS and I am using the same database structure.

rufus05 · Accepted Answer · 2020-05-20 20:52:51Z

1

I managed to import the .csv through the Windows terminal with the following command:

psql --host xxxxxxxxxxxx.us-east-1.rds.amazonaws.com --port 5432 --username postgres --dbname newDatabase -c "\copy public.tableTest FROM 'C:\Temp\tableTest.csv' DELIMITER ';' CSV HEADER ENCODING 'LATIN1';"

answered May 20, 2020 at 20:52

rufus05

431 silver badge10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error import from .csv to table - Postgres - AWS-RDS

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related