[Go-essp-tech] Idempotent SQL?

[Gavin M. Bell]

 Hi,

:-(
I tried that... it doesn't work for postgres :-|.
I am trying to find the analogous command for postgres.

(maybe we should just use H2...) ;-).
 

On 2/4/11 9:50 AM, Cinquini, Luca (3880) wrote:
> Hi Gavin,
> this kind of statements worked for Java H2DB - not sure about postgres...
>
> -- WORKFLOW INSTANCE TYPE
> CREATE TABLE IF NOT EXISTS WORKFLOW_INSTANCE_TYPE (
> TYPE INT PRIMARY KEY NOT NULL,
> DESCRIPTION VARCHAR(200) NOT NULL
> );
> MERGE INTO WORKFLOW_INSTANCE_TYPE (TYPE, DESCRIPTION ) VALUES (1,
> 'DESDynI Standard');
>
> Luca
>
> On Feb 4, 2011, at 10:45 AM, Gavin M. Bell wrote:
>
>> Hey SQL Mavens...
>>
>> Does anyone know how to create idempotent SQL scripts?
>> If something is there already, then don't create it...
>> If it is not, then do so.
>> (the pithier the better)
>>
>> Thanks
>> -- 
>> Gavin M. Bell
>> Lawrence Livermore National Labs
>> --
>>
>>  "Never mistake a clear view for a short distance."
>>        	       -Paul Saffo
>>
>> (GPG Key - http://rainbow.llnl.gov/dist/keys/gavin.asc)
>>
>>  A796 CE39 9C31 68A4 52A7  1F6B 66B7 B250 21D5 6D3E
>> _______________________________________________
>> GO-ESSP-TECH mailing list
>> GO-ESSP-TECH at ucar.edu <mailto:GO-ESSP-TECH at ucar.edu>
>> http://mailman.ucar.edu/mailman/listinfo/go-essp-tech
>

-- 
Gavin M. Bell
Lawrence Livermore National Labs
--

 "Never mistake a clear view for a short distance."
       	       -Paul Saffo

(GPG Key - http://rainbow.llnl.gov/dist/keys/gavin.asc)

 A796 CE39 9C31 68A4 52A7  1F6B 66B7 B250 21D5 6D3E

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ucar.edu/pipermail/go-essp-tech/attachments/20110204/f1a47ee1/attachment.html