SyntaxFix
Write A Post
Hire A Developer
Questions
You can make use of VALUES - available in Postgres:
INSERT INTO person (name) SELECT name FROM person UNION VALUES ('Bob') EXCEPT SELECT name FROM person;