Home > mailing lists

Re: Insert data if it is not existing - Mailing list pgsql-general

From	David G. Johnston
Subject	Re: Insert data if it is not existing
Date	May 24, 2018 08:55:36
Msg-id	CAKFQuwaJWA_W7Lq_HcXo0jYR8PGJjGZsNPAbDChOR9u1QLCpEQ@mail.gmail.com Whole thread Raw
In response to	Re: Insert data if it is not existing (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses	Re: Insert data if it is not existing
List	pgsql-general

On Wednesday, May 23, 2018, Adrian Klaver <adrian.klaver@aklaver.com> wrote:

INSERT INTO my_table(%s, %s)
WHERE NOT EXISTS(SELECT name FROM my_table WHERE name= %s)

INSERT doesn't have a where clause...

David J.

From: Adrian Klaver
Date: 24 May 2018, 08:51:46
Subject: Re: Insert data if it is not existing

From: tango ward
Date: 24 May 2018, 08:59:22
Subject: Re: Insert data if it is not existing