Skip to content

Instantly share code, notes, and snippets.

@ugnb

ugnb/bulk_update.sql

Created December 11, 2017 17:05
Show Gist options
  • Save ugnb/af880e05c3a70bb108ee175a47d97165 to your computer and use it in GitHub Desktop.
Save ugnb/af880e05c3a70bb108ee175a47d97165 to your computer and use it in GitHub Desktop.
Download ZIP
Postgres bulk update records
Raw
bulk_update.sql
UPDATE table_name
SET (column1, column2, column3) =
(
data_table.column1,
data_table.column2,
data_table.column3
)
FROM (
SELECT
unnest(array[@Column1Values]) as column1,
unnest(array[@Column2Values]) as column2,
unnest(array[@Column3Values]) as column3,
unnest(array[@Ids]) as id
) as data_table
WHERE id = data_table.id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment