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
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 |