The Postgres INSERT documentation has an example of using ON CONFLICT:
INSERT INTO distributors (did, dname) VALUES (7, 'Redline GmbH')
ON CONFLICT (did) DO NOTHING;
I try the same thing:
INSERT INTO name_map VALUES ('key_value', 'val1','val2')
ON CONFLICT (key_column) DO NOTHING;
But get an error ERROR: syntax at or near "ON".
What am I missing?
postgres --version
> 9.5.0
source
share