Search Postgresql Archives

Copying data from one column to another

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

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[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