Search Postgresql Archives

Re: Insert data if it is not existing

Subject: Re: Insert data if it is not existing
From: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Wed, 23 May 2018 19:55:36 -0700
Cc: tango ward <tangoward15@xxxxxxxxx>, "pgsql-generallists.postgresql.org" <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <d6d43665-fdfa-3b88-959f-9bcacc9c1466@aklaver.com>
References: <CAA6wQL+TssWQBKuysQWwOK6ggZ5niLiRXhHbZt8hZTC+qsfwXQ@mail.gmail.com> <CAKFQuwbovigqheUFx04dr41+H6DbNsRW_meB-w072SFeAPj7vg@mail.gmail.com> <0a76f762-88d8-75a7-de3c-d76094638fdd@aklaver.com> <CAA6wQLKH+djOs9xVFWB5pG9DN_nD8dQrrdOQtB0=8NdVy93KYA@mail.gmail.com> <CAKFQuwa7JFd0ayELKnFD7KmmgNZxTLX_=KVBBqyzq50ngof0Pw@mail.gmail.com> <CAA6wQLJ_WNLca0psVifB4Krfz70nJHZVhcnJKZn4EaN3BWy+3g@mail.gmail.com> <c9b652fb-13d6-5a40-0ec4-68d12201e1ef@aklaver.com> <CAA6wQLJTXC=TRpLocBkjGtnq4sme7TD6uFG1+rtQRabimo_Q5g@mail.gmail.com> <d6d43665-fdfa-3b88-959f-9bcacc9c1466@aklaver.com>

On Wednesday, May 23, 2018, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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.

Follow-Ups:
- Re: Insert data if it is not existing
  - From: tango ward

References:
- Insert data if it is not existing
  - From: tango ward
- Re: Insert data if it is not existing
  - From: David G. Johnston
- Re: Insert data if it is not existing
  - From: Adrian Klaver
- Re: Insert data if it is not existing
  - From: tango ward
- Re: Insert data if it is not existing
  - From: David G. Johnston
- Re: Insert data if it is not existing
  - From: tango ward
- Re: Insert data if it is not existing
  - From: Adrian Klaver
- Re: Insert data if it is not existing
  - From: tango ward
- Re: Insert data if it is not existing
  - From: Adrian Klaver