[GENERAL] Merge - Insert Select - Mailing list pgsql-general

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.hurst@brookhurstdata.com



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general