X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 9D45ED1EB4C for ; Fri, 7 May 2004 08:16:49 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 23500-03 for ; Fri, 7 May 2004 08:16:31 -0300 (ADT) Received: from fep01-mail.bloor.is.net.cable.rogers.com (fep01-mail.bloor.is.net.cable.rogers.com [66.185.86.71]) by svr1.postgresql.org (Postfix) with ESMTP id A90CED1ECA5 for ; Fri, 7 May 2004 08:16:26 -0300 (ADT) Received: from phlogiston.dydns.org ([65.49.125.184]) by fep01-mail.bloor.is.net.cable.rogers.com (InterMail vM.5.01.05.12 201-253-122-126-112-20020820) with ESMTP id <20040507111440.JJEW79524.fep01-mail.bloor.is.net.cable.rogers.com@phlogiston.dydns.org> for ; Fri, 7 May 2004 07:14:40 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 4B5C43CF4; Fri, 7 May 2004 07:16:28 -0400 (EDT) Date: Fri, 7 May 2004 07:16:28 -0400 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: EXPORT / IMPORT Message-ID: <20040507111628.GB14119@phlogiston.dyndns.org> Mail-Followup-To: pgsql-sql@postgresql.org References: <92EFB0BEDD24E9419E2CD9A2BD35DAEA0439BC@bmsrv001.madrid.bilbomatica.es> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <92EFB0BEDD24E9419E2CD9A2BD35DAEA0439BC@bmsrv001.madrid.bilbomatica.es> User-Agent: Mutt/1.5.5.1+cvs20040105i X-Authentication-Info: Submitted using SMTP AUTH LOGIN at fep01-mail.bloor.is.net.cable.rogers.com from [65.49.125.184] using ID at Fri, 7 May 2004 07:14:39 -0400 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200405/68 X-Sequence-Number: 17782 On Fri, May 07, 2004 at 10:20:52AM +0200, Freddy Villalba Arias wrote: > > Is there a simple way to generate an export / import script in > PostgreSQL (i.e. a script that contains INSERT statements for every row > in a table) ??? > > COPY is NOT a good option (personal opinion). pg_dump -d or -D. Note that restoring from this is going to be a whole lot slower than restoring from a COPY based dump. A -- Andrew Sullivan | ajs@crankycanuck.ca