Copying data from one column to another

From: "Nels Lindquist" <nlindq(at)maei(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Copying data from one column to another
Date: 2005-11-01 23:03:59
Message-ID: 436791EC.13351.6ABBC1D@nlindq.maei.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi there.

Sorry if this is a silly question, I'm relatively new to PostgreSQL.

I'm trying to copy information from one column, modify it and place
it in another column. Is there some shortcut way to do this with an
UPDATE statement?

So far I'm thinking I'll need to copy the table schema and then
INSERT...SELECT using the desired expressions. Does that seem
reasonable?

----
Nels Lindquist <*>
Information Systems Manager
Morningstar Air Express Inc.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2005-11-01 23:34:14 Re: Copying data from one column to another
Previous Message Rory Browne 2005-11-01 22:59:53 Re: Disappearing Records