Received: from mailout00.sul.t-online.de (mailout00.sul.t-online.com [194.25.134.16]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6AJaUa66424 for ; Tue, 10 Jul 2001 15:36:30 -0400 (EDT) (envelope-from A_Schnabel@t-online.de) Received: from fwd02.sul.t-online.de by mailout00.sul.t-online.de with smtp id 15K3J6-0002Ro-01; Tue, 10 Jul 2001 21:36:28 +0200 Received: from taska (520019441306-0001@[62.226.22.19]) by fwd02.sul.t-online.com with smtp id 15K3Iq-1mL0iWC; Tue, 10 Jul 2001 21:36:12 +0200 Message-ID: <004801c10977$8ae4e760$0201a8c0@aschnabel.homeip.net> From: A_Schnabel@t-online.de (Andre Schnabel) To: "ML: Postgres SQL" Subject: Re: Problems with PG_DUMP and restore Date: Tue, 10 Jul 2001 21:35:56 +0200 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_0045_01C10988.4DCD7FC0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Sender: 520019441306-0001@t-dialin.net X-Archive-Number: 200107/113 X-Sequence-Number: 3898 This is a multi-part message in MIME format. ------=_NextPart_000_0045_01C10988.4DCD7FC0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi, >In an effort to do some general cleanup in my database functions, I >dumped the schema (pgdump -s) and the data (pgdump -a) to seperate text >files. I'm using a similar method for my own project. But I dump the data with the -d or -D option. This ist not as fast as the raw copy but more flexible. Maybe you should give it a try. If you rename some colums of your table, you should use -d (propert INSERT commands instead of COPY). If you reorder the colums of your tables you should use -D (propert INSERT with explicit Attributenames). You cannot do both (rename and reorder columns)! Andre ------=_NextPart_000_0045_01C10988.4DCD7FC0 Content-Type: text/x-vcard; name="Andre Schnabel.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="Andre Schnabel.vcf" BEGIN:VCARD VERSION:2.1 N:Schnabel;Andre FN:Andre Schnabel NICKNAME:Thalion X-WAB-GENDER:2 BDAY:19720509 EMAIL;INTERNET:a_schnabel@gmx.de EMAIL;PREF;INTERNET:a_schnabel@t-online.de REV:20010710T193556Z END:VCARD ------=_NextPart_000_0045_01C10988.4DCD7FC0--