check row before insert - Mailing list pgsql-novice

From SG Edwards
Subject check row before insert
Date
Msg-id 1110890937.4236d9b950ba0@sms.ed.ac.uk
Whole thread Raw
Responses Re: check row before insert
List pgsql-novice
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 preset in the database. Is there a way to
do this using an SQL command?


Thanks

pgsql-novice by date:

Previous
From: "Christian Hofmann"
Date:
Subject: Problem: Joining each column of a "one row query" with the result of a "many row query"
Next
From: Bruno Wolff III
Date:
Subject: Re: check row before insert