Check before insert - Mailing list pgsql-interfaces

From SG Edwards
Subject Check before insert
Date
Msg-id 1110920863.42374e9f75aa1@sms.ed.ac.uk
Whole thread Raw
Responses Re: Check before insert
List pgsql-interfaces

Hi,

I have a table as follows:

protein_id | name
___________ ______

P04667      Albumin
P45366      Lactoglobulin
....
etc

I have a perl script that will insert data into this table from a file
containing a list of protein_id and names. However, I only want to insert
proteins where they are not already present in the database. Is there a way to
do this using an SQL command?


Thanks



pgsql-interfaces by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Using PL/R with 8.0
Next
From: Robert Perry
Date:
Subject: Re: Check before insert