Re: restore/dup OIDs HELP!

From: "David F(dot) Skoll" <dfs(at)roaringpenguin(dot)com>
To: Jack Flak <jack(at)flak(dot)nospam(dot)org>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: restore/dup OIDs HELP!
Date: 2003-01-06 17:57:31
Message-ID: Pine.LNX.4.50.0301061255360.3494-100000@shishi.roaringpenguin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2003-01-06 18:42:18 Re: restore/dup OIDs HELP!
Previous Message Theodore A. Jencks 2003-01-06 15:06:49 pg_restore not working.