Re: pg_dump ORDER BY - Mailing list pgsql-novice

From Joel Burton
Subject Re: pg_dump ORDER BY
Date
Msg-id 3A2FCCF9.18817.10C512@localhost
Whole thread Raw
In response to pg_dump ORDER BY  (Nabil Sayegh <nsmail@sayegh.de>)
List pgsql-novice
> Hi,
>
> I did a mistake lastnight.
> I have 2 databases of the same structure: db1, db2
>
> Now I need to pg_dump them and do a diff.
> Therefor I need the contents of the tables to be ordered.

If you have databases (db1 and db2) and two tables in each
(t1 and t2), I think it would be easiest to dump each table
independently (pg_dump -t t1 d1 > /tmp/d1t1) and diff that to its
sister table.

You could pretty easily turn diff into COPY input.

If you do a full pg_dump of the database, you'll get non-data stuff,
like all of the sequences, index declarations, etc. (Unless *that's*
what you want to reconcile.)

--
Joel Burton, Director of Information Systems -*- jburton@scw.org
Support Center of Washington (www.scw.org)

pgsql-novice by date:

Previous
From: "Joel Burton"
Date:
Subject: Re: Install order
Next
From: "Joel Burton"
Date:
Subject: Re: Install order