better way?

[Pet]

On 11 Aug., 20:39, Kushal Kumaran <kushal.kumaran+pyt... at gmail.com>
wrote:
> On Tue, Aug 11, 2009 at 10:03 PM, someone<petshm... at googlemail.com> wrote:
> > Hello,
>
> > I'd like to make insert into db if record not exist otherwise update.
> > to save typing list of columns in both statements I do following
>
> > <snip>
>
> > is there better or more readable way to do it?
>
> Well, mysql, in particular, offers an "on duplicate key update" clause
> that you can take a look at.  Don't know about about other databases.
>
> --
> kushal

Oh, forgotten to mention. It's PostGres