Skip to content

Instantly share code, notes, and snippets.

@rohit-gupta

rohit-gupta/postgres upsert

Created January 31, 2015 04:40
Show Gist options
  • Save rohit-gupta/5806b68d022beb05c37e to your computer and use it in GitHub Desktop.
Save rohit-gupta/5806b68d022beb05c37e to your computer and use it in GitHub Desktop.
Download ZIP
query to carry out an upsert in postgres
Raw
postgres upsert
begin;
lock my_table in exclusive mode;
delete from my_table where key='key';
insert into my_table (key, value) values ('key', 'value');
commit;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment