Copying data from one column to another - Mailing list pgsql-general

From Nels Lindquist
Subject Copying data from one column to another
Date
Msg-id 436791EC.13351.6ABBC1D@nlindq.maei.ca
Whole thread Raw
Responses Re: Copying data from one column to another  (Tino Wildenhain <tino@wildenhain.de>)
List 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.


pgsql-general by date:

Previous
From: Tino Wildenhain
Date:
Subject: Re: SQL injection
Next
From: Tino Wildenhain
Date:
Subject: Re: Copying data from one column to another