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
"The dinosaurs became extinct because they didn't have a space program."
pgsql-novice by date
|Next:||From: kerryb||Date: 2000-07-03 11:00:48|
|Subject: Re: Installation error |
|Previous:||From: Tom Lane||Date: 2000-06-30 16:54:11|
|Subject: Re: Problems with fatal errors on startup of postmaster. |