Skip to content

Instantly share code, notes, and snippets.

@andybeak

andybeak/gist:750afee1bccd3e3fddf3

Created March 30, 2015 14:59
Show Gist options
  • Save andybeak/750afee1bccd3e3fddf3 to your computer and use it in GitHub Desktop.
Save andybeak/750afee1bccd3e3fddf3 to your computer and use it in GitHub Desktop.
Download ZIP
Ignore duplicate inserts in Postgre SQL
Raw
gistfile1.sql
CREATE OR REPLACE RULE db_table_ignore_duplicate_inserts AS
ON INSERT TO db_table
WHERE (EXISTS ( SELECT 1
FROM db_table
WHERE db_table.tbl_column = NEW.tbl_column)) DO INSTEAD NOTHING;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment