joining separate databases
От | bill@wadley.org |
---|---|
Тема | joining separate databases |
Дата | |
Msg-id | Pine.LNX.4.21.6912311759590.3228-100000@wadley.org обсуждение исходный текст |
Список | 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@Wadley.org Bill.Wadley.org/PGP_KEY.html "The dinosaurs became extinct because they didn't have a space program." -Larry Niven
В списке pgsql-novice по дате отправления: