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 E129452801 for ; Tue, 28 Jun 2005 17:04:55 -0300 (ADT) 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 37007-01 for ; Tue, 28 Jun 2005 20:04:52 +0000 (GMT) Received: from titan.ecommit.de (titan.ecommit.de [195.145.58.245]) by svr1.postgresql.org (Postfix) with ESMTP id 176F3529D6 for ; Tue, 28 Jun 2005 17:04:50 -0300 (ADT) Received: from titan.ecommit.de (localhost [127.0.0.1]) by titan.ecommit.de (8.12.6/8.12.6/SuSE Linux 0.6) with ESMTP id j5SK4m0F018280; Tue, 28 Jun 2005 22:04:48 +0200 Received: from titan.ecommit.de (root@localhost) by titan.ecommit.de (8.12.6/8.12.6/Submit) with ESMTP id j5SK4mM0018279; Tue, 28 Jun 2005 22:04:48 +0200 Received: from [192.168.0.12] (p54A67EF6.dip.t-dialin.net 84.166.126.246) by titan.ecommit.de (Scalix SMTP Relay 9.0.0.26) via ESMTP; Tue, 28 Jun 2005 22:04:46 +0200 (CEST) Date: Tue, 28 Jun 2005 22:04:39 +0200 From: "Martin Fandel" To: chen@musc.edu Cc: pgsql-admin@postgresql.org Message-ID: <1119989080.8406.10.camel@localhost.localdomain> In-Reply-To: <42C18860.1010906@musc.edu> References: <42C15044.4030407@musc.edu> References: <1119974365.18693.16.camel@fandelm.ecommit.de> References: <42C18860.1010906@musc.edu> Subject: Re: change existing table definition x-scalix-Hops: 1 X-Mailer: Evolution 2.0.4 (2.0.4-4) Mime-Version: 1.0 Content-Type: text/plain Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.04 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/270 X-Sequence-Number: 18025 > pg_dump -c -t > > psql < I don't tested this but i think this works. Be dangerous with the "-c" Option of dump ;). After the dump was created, new data could be inserted into the database. If you dump in the file, all dumped tables are dropped. It's better to RENAME the existing table and then COPY in the data. greetings, Martin Am Dienstag, den 28.06.2005, 13:26 -0400 schrieb Chuming Chen: > pgsql-admin@postgresql.org