Migrating Data Between PG Tables

From: Mike Darretta <michael(dot)darretta(dot)ctr(at)metnet(dot)navy(dot)mil>
To: pgsql-admin(at)postgresql(dot)org
Subject: Migrating Data Between PG Tables
Date: 2004-10-05 20:13:54
Message-ID: 41630082.4090802@metnet.navy.mil
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message banghe 2004-10-05 20:21:55 Re: Migrating Data Between PG Tables
Previous Message Gonzales,S 2004-10-05 17:12:38 Running 2 postmaster Instances on different ports