X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5EC1732A1FC for ; Tue, 5 Oct 2004 21:14:05 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 38560-02 for ; Tue, 5 Oct 2004 20:14:00 +0000 (GMT) Received: from mail.metnet.navy.mil (jade.metnet.navy.mil [192.16.167.28]) by svr1.postgresql.org (Postfix) with SMTP id 154A632A1CE for ; Tue, 5 Oct 2004 21:13:58 +0100 (BST) Received: (qmail 24506 invoked from network); 5 Oct 2004 20:13:55 -0000 Received: from unknown (HELO ?127.0.0.1?) (10.100.105.103) by mail.metnet.navy.mil with SMTP; 5 Oct 2004 20:13:55 -0000 Message-ID: <41630082.4090802@metnet.navy.mil> Date: Tue, 05 Oct 2004 13:13:54 -0700 From: Mike Darretta User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.3) Gecko/20040910 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Migrating Data Between PG Tables References: <200410050159.i951xOH02113@candle.pha.pa.us> In-Reply-To: <200410050159.i951xOH02113@candle.pha.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/93 X-Sequence-Number: 15086 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