Re: to copy a record - Mailing list pgsql-general

From Jay O'Connor
Subject Re: to copy a record
Date
Msg-id 20030604155029.I874@altaica
Whole thread Raw
In response to Re: to copy a record  ("Jim C. Nasby" <jim@nasby.net>)
Responses Re: to copy a record
List pgsql-general
On 2003.06.04 12:48 Jim C. Nasby wrote:
> SELECT * INTO TEMP temp_table FROM blah;
> UPDATE temp_table SET field = newvalue;
> INSERT INTO blah SELECT * FROM temp_table;


Looks sweet.  Much simpler what I was doing, too


Thanks

Take care,
Jay

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Nulls get converted to 0 problem
Next
From: Avi Schwartz
Date:
Subject: Is jdbc.postgresql.org down?