Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Rajan, Pavithra" <RAJANP@xxxxxxxxx>
Subject: Re: Need help on updating an entire column with a list of values, I have.
From: Grzegorz Jaśkiewicz <gryzman@xxxxxxxxx>
Date: Fri, 26 Mar 2010 14:21:22 +0000
Cc: Timo Klecker <klecker@xxxxxxxxx>, pgsql-general@xxxxxxxxxxxxxx
In-reply-to: <BE29E09321056B4C9082D207759A692801DADC1F@xxxxxxxxxxxxxxxxxxxxxx>

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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Need help on updating an entire column with a list of values, I have.
  - From: Szymon Guz

References:
- Need help on updating an entire column with a list of values, I have.
  - From: Rajan, Pavithra
- Re: Need help on updating an entire column with a list of values, I have.
  - From: Timo Klecker
- Re: Need help on updating an entire column with a list of values, I have.
  - From: Rajan, Pavithra

Prev by Date: Re: Does anyone use in ram postgres database?
Next by Date: Re: Does anyone use in ram postgres database?
Previous by thread: Re: Need help on updating an entire column with a list of values, I have.
Next by thread: Re: Need help on updating an entire column with a list of values, I have.
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux