What is the best practice for doing an INSERT...SELECT statement for new
values only. Existing values must be excluded from the insert.
Does postgres have a MERGE statement ala Oracle?
I have found examples online for INSERT...ON CONFLICT DO NOTHING, but
all of those examples use VALUES statements, which is not the scenario
that I have.
Thanks for your help!
Sue
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Susan E Hurst
Principal Consultant
Brookhurst Data LLC
Email: susan(dot)hurst(at)brookhurstdata(dot)com