How to use "WHERE NOT EXISTS in INSERT STATEMENT"

From: Serge Christian Ibala <christian(dot)ibala(at)gmail(dot)com>
To: psycopg(at)postgresql(dot)org
Subject: How to use "WHERE NOT EXISTS in INSERT STATEMENT"
Date: 2016-02-19 20:00:59
Message-ID: CABsq6iyHGcH0EN9t+V5cvOyZh0PMHpdLVE6P_tUbgFaRjyZqGQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

Hello All,

I want to insert some data in my data base (postgrsql) using Python but i
want to check first that the row does not already exist.
The normal command is:

cur.execute("INSERT INTO COMPANYLIST (ID, NAME, AGE, ADDRESS, SALARY) \
VALUES (1, 'Paul', 32, 'California', 20000.00)");

I get the error below when running the code twice.

===================================================

*psycopg2.IntegrityError: duplicate key value violates unique
constraint "companylist_pkey"
DETAIL: Key (id)=(1) already exists.*

====================================================

I have tried to replace it by:

cur.execute("INSERT INTO COMPANYLIST (ID, NAME, AGE, ADDRESS, SALARY) \
WHERE NOT EXISTS (SELECT 1 FROM table WHERE id='1')\
VALUES (1, 'Paul', 32, 'California', 20000.00)");

It does not work. Can anybody please help?
Kind Regards,
Christian

Responses

Browse psycopg by date

  From Date Subject
Next Message Alan Evans 2016-02-19 23:34:39 PQntuples for older version (2.2.1) of psycopg2 with ctypes
Previous Message Adrian Klaver 2016-02-18 15:47:31 Re: Using pgAdminIII to view the data written in PostGreSQL