From: A_Schnabel@t-online.de
To: ML: Postgres SQL <pgsql-sql@postgresql.org>
Subject: Re: Problems with PG_DUMP and restore
Date: Tue, 10 Jul 2001 21:35:56 +0200
Message-ID: <004801c10977$8ae4e760$0201a8c0@aschnabel.homeip.net> (raw)
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
Attachments:Andre Schnabel.vcf (text/x-vcard, 211B) download
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: A_Schnabel@t-online.de
Subject: Re: Problems with PG_DUMP and restore
In-Reply-To: <004801c10977$8ae4e760$0201a8c0@aschnabel.homeip.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox