pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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

view thread (5+ messages)  latest in thread

Message-ID: <004801c10977$8ae4e760$0201a8c0@aschnabel.homeip.net>
Permalink:  ../004801c10977$8ae4e760$0201a8c0@aschnabel.homeip.net/
Also on:    postgresql.org/message-id/004801c10977$8ae4e760$0201a8c0@aschnabel.homeip.net

 · 

reply

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