One sql statement can solve this:
sql> isnert into table_b (id, name, summary) select id, name, desc from table_a;
Banghe
Mike Darretta wrote:
Does anyone have a suggestion on the best way to migrate data between two slightly different tables? For example:
Table A -------- id : integer name : string desc : string
Table B -------- id : integer name : string date : date summary : string
In this example, I would like to copy all the data from Table A into B, using the desc column to populate the summary column.
Thanks, Mike
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
