Copy from csv to update Table PSQL

copyFromCsvToPSQL

psql -h <dbhost> -U <user> -d <dbName> 

CREATE TEMP TABLE tmp_x (venue_id int, address1 text);
CREATE TEMP TABLE tmp_x (id int, columnToUpdate text);
\copy tmp_x FROM '/absolute/path/to.csv'  with (format csv,header true, delimiter ',');
UPDATE original_table
SET    columnToUpdate = tmp_x.columnToUpdate
FROM   tmp_x
WHERE  original_table.id = tmp_x.id;

DROP TABLE tmp_x; -- else it is dropped at end of session automatically

From : https://stackoverflow.com/questions/8910494/how-to-update-selected-rows-with-values-from-a-csv-file-in-postgres/8910810