switching between insert and update - Mailing list pgsql-novice

From Travis Hoyt
Subject switching between insert and update
Date
Msg-id DBEMKMGOMJAGKAKEPPEGKEENDFAA.thoyt@npc.net
Whole thread Raw
List pgsql-novice
Not sure if this is the right list but here goes:

I've got a perl script that inserts some data.  Simple enough, but my
problem is that it fails when I try to insert more data that contains the
same time and id.  Is there an easy way of switching from an INSERT to an
UPDATE and does anyone know of any examples?  There's one more piece to
this puzzle.  The columns names and number of columns addressed are
dynamic and will change for each file loaded into the database.

Thanks,

Travis

Attachment

pgsql-novice by date:

Previous
From: Nick Haw
Date:
Subject: Re: Conditional constraint?
Next
From: "Josh Berkus"
Date:
Subject: Re: rules over multiple tables