Import of CSV file data to PostgreSQL table automation

Question

Below import command works fine if the nrgcore.bookmarks table is empty, please let me know how to include 'truncate table ngrcore.bookmarks' in the below command so that it first truncate the table and then import the data successfully.

psql -U nrgadmin -d enwdb -c "COPY nrgcore.bookmarks(login, application, description, centerx, centery, scale, bookmarkid, path) FROM 'D:\Bookmarks_Table\Bookmarks.csv' DELIMITER ',' CSV HEADER"

Any help/suggestion would be much appreciated.

Add the TRUNCATE statement before COPY in the -c option, separated by a semicolon. — Laurenz Albe
– Laurenz Albe, Commented Sep 3, 2018 at 13:32

Udit Solanki · Accepted Answer · 2018-09-03 13:38:43Z

2

Instead of passing inline query, You can create one sql file that contains below :

TRUNCATE TABLE nrgcore.bookmarks;

COPY nrgcore.bookmarks(login, application, description, centerx, centery, scale, bookmarkid, path) FROM 'D:\Bookmarks_Table\Bookmarks.csv' DELIMITER ',' CSV HEADER;

And pass it in your command line argument:

psql -U nrgadmin -d enwdb -f import.sql

answered Sep 3, 2018 at 13:38

Udit Solanki

5315 silver badges12 bronze badges

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

2 Comments

Udit Solanki Over a year ago

Glad i could help. But be careful with truncate.

Anil Kumar Over a year ago

Yup no problem. I'm aware of it. Thanks.

Collectives™ on Stack Overflow

Import of CSV file data to PostgreSQL table automation

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related