Postgres Pro
Downloads
Home   >   mailing lists

Testing for existence of a record before insert - Mailing list pgsql-admin

From Rob Anderson
Subject Testing for existence of a record before insert
Date
Msg-id FHEPJNONMOLHMPDJDOCMOEPHFGAA.roba@bml.uk.com
Whole thread Raw
Responses Re: Testing for existence of a record before insert  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-admin
Tree view
I am trying to find a way of performing something similar to the SQL-Server SQL of
 
IF NOT EXISTS (SELECT id FROM a_table WHERE id='akey')
THEN INSERT INTO a_table (id, name) values ('akey', 'adetails');
 
 

pgsql-admin by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Slow Foreign Key
Next
From: Bruno Wolff III
Date:
Subject: Re: Testing for existence of a record before insert