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 CAA6wQLJ_WNLca0psVifB4Krfz70nJHZVhcnJKZn4EaN3BWy+3g@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
List pgsql-general
Tree view
Sorry, i forgot the values.

curr.pgsql.execute('''
INSERT INTO my_table(name, age)
SELECT name, age
WHERE NOT EXISTS(SELECT name FROM my_table WHERE name= name)
''', ('Scott', 23))

Sorry, I don't understand, where should I place the from clause? I just saw a sample code like this in SO, so I gave it a shot


On Thu, May 24, 2018 at 8:04 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Wednesday, May 23, 2018, tango ward <tangoward15@gmail.com> wrote:
Thanks masters for responding again.

I've tried running the code:

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


this doesn't give me error but it doesn't insert data either.


I'm doubting your assertion that it doesn't error.   How do you run that query such that age and name are recognized given the main query doesn't have a from clause?

David J.

pgsql-general by date:

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