Skip site navigation (1) Skip section navigation (2)

joining separate databases

From: bill(at)wadley(dot)org
To: pgsql-novice(at)postgresql(dot)org
Subject: joining separate databases
Date: 2000-07-02 22:06:45
Message-ID: Pine.LNX.4.21.6912311759590.3228-100000@wadley.org (view raw or flat)
Thread:
Lists: pgsql-novice
Hello!

This may be missing the mark completely, but I figured I would ask:

I have a database containing our customers and our information product, and
I'm working on an internal project management app that will be stored in
another database (different machine, even).

Now, it occurs to me that I will want to join some tables from one database
with some tables in another one in-a-while, for instance if a customer is
responsible for a project, their contact information should be pulled from
the first database.

Or, to put it another way, I have two completely different problem domains
that intersect. I have a database for each domain. What if I want to join
them in some way? It just doesn't seem right to put every single table my
company creates into the same database, but I may be wrong.

Can anyone tell me where I'm going with this? Is there a school of thought,
or best practices, that I'm looking for? Anyone have a subject that can be
searched for?

Thanks!

--
Bill(at)Wadley(dot)org
Bill.Wadley.org/PGP_KEY.html
"The dinosaurs became extinct because they didn't have a space program."
 -Larry Niven


pgsql-novice by date

Next:From: kerrybDate: 2000-07-03 11:00:48
Subject: Re: Installation error
Previous:From: Tom LaneDate: 2000-06-30 16:54:11
Subject: Re: Problems with fatal errors on startup of postmaster.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group