Re: [GENERAL] combining db's- importing primary keys

2009-07-29 Thread Chris
Chris wrote: Bob Gobeille wrote: On Jul 29, 2009, at 8:26 AM, nha wrote: Hello, Le 29/07/09 15:02, Jasen Betts a écrit : On 2009-07-27, Bob Gobeille wrote: I would like to combine multiple databases (same schema) into one master db. Does anyone know how I can reconcile all my primary an

Re: [GENERAL] combining db's- importing primary keys

2009-07-29 Thread Chris
Bob Gobeille wrote: On Jul 29, 2009, at 8:26 AM, nha wrote: Hello, Le 29/07/09 15:02, Jasen Betts a écrit : On 2009-07-27, Bob Gobeille 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

Re: [GENERAL] combining db's- importing primary keys

2009-07-29 Thread nha
Hello, Le 29/07/09 16:44, Bob Gobeille a écrit : > > On Jul 29, 2009, at 8:26 AM, nha wrote: > >> Hello, >> >> Le 29/07/09 15:02, Jasen Betts a écrit : >>> On 2009-07-27, Bob Gobeille wrote: I would like to combine multiple databases (same schema) into one master db. Does anyone kno

Re: [GENERAL] combining db's- importing primary keys

2009-07-29 Thread Bob Gobeille
On Jul 29, 2009, at 8:26 AM, nha wrote: Hello, Le 29/07/09 15:02, Jasen Betts a écrit : On 2009-07-27, Bob Gobeille 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 referent

Re: [GENERAL] combining db's- importing primary keys

2009-07-29 Thread nha
Hello, Le 29/07/09 15:02, Jasen Betts a écrit : > On 2009-07-27, Bob Gobeille 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

Re: [GENERAL] combining db's- importing primary keys

2009-07-29 Thread Bob Gobeille
On Jul 29, 2009, at 7:02 AM, Jasen Betts wrote: On 2009-07-27, Bob Gobeille 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 some

Re: [GENERAL] combining db's- importing primary keys

2009-07-29 Thread Jasen Betts
On 2009-07-27, Bob Gobeille 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

[GENERAL] combining db's- importing primary keys

2009-07-27 Thread Bob Gobeille
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. Many thanks, Bob -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to you