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.


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to