Re: restore/dup OIDs HELP! - Mailing list pgsql-admin

From David F. Skoll
Subject Re: restore/dup OIDs HELP!
Date
Msg-id Pine.LNX.4.50.0301061255360.3494-100000@shishi.roaringpenguin.com
Whole thread Raw
In response to restore/dup OIDs HELP!  (Jack Flak <jack@flak.nospam.org>)
List pgsql-admin
On Sun, 5 Jan 2003, Jack Flak wrote:

> So, once again, here's my question:  how do I go about deleting the
> duplicate entries WITHOUT also deleting the originals?

Maybe a dump with some awk/perl magic followed by a restore might be
the easiest way. :-(

"pg_dump -a -D" might give output that is fairly amenable to munging;
a bit of text editing followed by sort | uniq might even do it.

--
David.

pgsql-admin by date:

Previous
From: Jack Flak
Date:
Subject: restore/dup OIDs HELP!
Next
From: Stephan Szabo
Date:
Subject: Re: restore/dup OIDs HELP!