Bulk upsert (insert-update) a csv in postgres

Asked Jun 16 '14 at 16:09

Active Jun 16 '14 at 16:12

Viewed 1,361 times

I'm looking for a good way to bulk "upsert" a csv. The table is:

category_id (indexed but not unique)      post_id (indexed and unique)

a post_id should only be represented once.

Is there a good way to do this?

To do a bulk insert I've used the COPY posts FROM 'posts.csv' CSV; in psql, but I've never done a bulk "where exists update, else insert" type of operation.

edited Jun 16 '14 at 16:12

Satwik Nadkarny

4,944
2
22
40

asked Jun 16 '14 at 16:09

mgoldwasser

13,242
13
72
100

3

Given that the data is in a csv, this is not a duplicate. – mgoldwasser Jun 16 '14 at 17:51
1

Start with a temporary staging table and proceed from there. http://stackoverflow.com/questions/8910494/how-to-update-selected-rows-with-values-from-a-csv-file-in-postgres/8910810#8910810 – Erwin Brandstetter Jun 16 '14 at 18:05
@ErwinBrandstetter fair enough - thanks! – mgoldwasser Jun 17 '14 at 16:24

Bulk upsert (insert-update) a csv in postgres

0 Answers0