Re: Need help on updating an entire column with a list of values, I have.

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: "Rajan, Pavithra" <RAJANP(at)coned(dot)com>
Cc: Timo Klecker <klecker(at)decoit(dot)de>, pgsql-general(at)postgresql(dot)org
Subject: Re: Need help on updating an entire column with a list of values, I have.
Date: 2010-03-26 14:21:22
Message-ID: 2f4958ff1003260721n29ad0e0ak21a79d6088d29d71@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

create temporary table, insert your data, and than run update with join
against the table you wish to modify. And than drop your temp table.
simple.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gordan Bobic 2010-03-26 14:23:31 Re: Does anyone use in ram postgres database?
Previous Message Alan McKay 2010-03-26 14:20:28 Re: Does anyone use in ram postgres database?