Postgres Pro
Downloads
Home   >   mailing lists

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

From tango ward
Subject Re: Insert data if it is not existing
Date
Msg-id CAA6wQLKER=WpBjpa+6Uzym0KwVFSSZ3LTzdcmKDy3Vh4LCDu6w@mail.gmail.com
Whole thread Raw
In response to Re: Insert data if it is not existing  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Insert data if it is not existing  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view

On Thu, May 24, 2018 at 10:55 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:
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. 


What I did is

'''INSERT INTO my_table(name, age)
SELECT %s, %s
WHERE NOT EXISTS(SELECT name FROM my_table WHERE name=%s)''', ('Scott', 23)

pgsql-general by date:

Previous
From: tango ward
Date:
Subject: Re: Insert data if it is not existing
Next
From: Adrian Klaver
Date:
Subject: Re: Insert data if it is not existing