Thread: [GENERAL] Merge - Insert Select
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
On Fri, Oct 13, 2017 at 9:39 AM, Susan Hurst <susan.hurst@brookhurstdata.com> wrote: > Does postgres have a MERGE statement ala Oracle? No. > 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. You can use SELECT instead of VALUES with ON CONFLICT DO NOTHING/ON CONFLICT DO UPDATE. They don't impose any restriction on the INSERT statement at all, unlike MERGE, which is fussy about the use of subqueries. -- Peter Geoghegan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general