Migrating Data Between PG Tables - Mailing list pgsql-admin

From Mike Darretta
Subject Migrating Data Between PG Tables
Date
Msg-id 41630082.4090802@metnet.navy.mil
Whole thread Raw
In response to Re: Enabling --log-update  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Migrating Data Between PG Tables  (banghe <banghe@baileylink.net>)
List pgsql-admin
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



pgsql-admin by date:

Previous
From: "Dirk J. Botha"
Date:
Subject: Building pgadmin3 from source
Next
From: banghe
Date:
Subject: Re: Migrating Data Between PG Tables