PostgreSQL insert or return id

Asked Jul 09 '21 at 19:56

Active Jul 09 '21 at 20:29

Viewed 104 times

I'm trying to insert or return id of existing value in case of uniqueness conflict (the data is already there).

I'm guessing it could be something like this, but can't quite get it to return the actual ID

INSERT INTO my_table (my_column) VALUES ('my value') 
ON CONFLICT DO NOTHING
RETURNING ID;

where my_column has a unique constraint.

Any ideas?

edited Jul 09 '21 at 20:05

asked Jul 09 '21 at 19:56

Joey Baruch

For context, this would be used as part of a nested insert of a datum into multiple normalized tables – Joey Baruch Jul 09 '21 at 19:57
1

do you have a unique constraint on your table for that column? – eshirvana Jul 09 '21 at 19:58

0 Answers0