Re: Incremental Dump - Mailing list pgsql-novice

From Nabil Sayegh
Subject Re: Incremental Dump
Date
Msg-id 1056636328.1270.2.camel@billy
Whole thread Raw
In response to Re: Incremental Dump  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Am Don, 2003-06-26 um 15.52 schrieb Tom Lane:

> I'd try pg_dump -s (schema only) and diff the two dumps.  You might have
> to do some fooling around if objects were created in different orders in
> the two databases, though, since that would affect the dump order.

I'd also remove all comments:

pg_dump -s dbname |egrep -v "^\-\-"

HTH
--
 e-Trolley Sayegh & John, Nabil Sayegh
 Tel.: 0700 etrolley /// 0700 38765539
 Fax.: +49 69 8299381-8
 PGP : http://www.e-trolley.de


pgsql-novice by date:

Previous
From: "Herbie McDuck"
Date:
Subject: Re: Incremental Dump
Next
From: "Chad Thompson"
Date:
Subject: Removing foreign key and adding sequence