Re: Question on MERGE in postgresql

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Kaleeswaran Velu <kaleeswaran(dot)velu(at)gmail(dot)com>
Cc: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Question on MERGE in postgresql
Date: 2017-02-18 15:39:53
Message-ID: CAKFQuwbdNj6mSTWi9NTDhm57zheFvep3hQcoR3BLGXxALB1zNw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Sat, Feb 18, 2017 at 8:32 AM, Kaleeswaran Velu <
kaleeswaran(dot)velu(at)gmail(dot)com> wrote:

> Greeting all,
> I am using postgresql 9.4. When I try to use "Merge" command, seems not
> working.
>
> ​There is no MERGE command in PostgreSQL

https://www.postgresql.org/docs/9.6/static/sql-commands.html

​Beginning with 9.5.x we do have: INSERT ... ON CONFLICT which is similar

https://www.postgresql.org/docs/9.5/static/sql-insert.html

David J.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Gaurav Tomar 2017-02-28 06:35:07 FDW Process ID (PID)
Previous Message Kaleeswaran Velu 2017-02-18 15:32:20 Question on MERGE in postgresql