Re: [ADMIN] Migrating Data Between PG Tables

2004-10-05 Thread Mike Darretta
banghe wrote: 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 : in

Re: [ADMIN] Migrating Data Between PG Tables

2004-10-05 Thread banghe
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 : s