Re: [ADMIN] Migrating Data Between PG Tables

[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 : 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]

Thanks. I figured it was simple...

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match