Re: combining db's- importing primary keys

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: combining db's- importing primary keys
Date: 2009-07-29 13:02:02
Message-ID: h4ph8a$pi$2@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2009-07-27, Bob Gobeille <bob(dot)gobeille(at)hp(dot)com> wrote:
> I would like to combine multiple databases (same schema) into one
> master db. Does anyone know how I can reconcile all my primary and
> foreign keys to maintain referential integrity.

prefix them all with something that's unique to their source database.

easy to say, hard to do.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message mzhang 2009-07-29 13:05:37 org.postgresql.util.PSQLException: PANIC: could not write to log file
Previous Message Jasen Betts 2009-07-29 12:58:27 Re: Clients disconnect but query still runs