Postgres Pro
Downloads
Home   >   mailing lists

Design suggestion of multiple databases vs multiple schemas within the database - Mailing list pgsql-general

From Swaminathan Saikumar
Subject Design suggestion of multiple databases vs multiple schemas within the database
Date
Msg-id 82692d4a0803021154r4c9fd44fh26b7021db8153d23@mail.gmail.com
Whole thread Raw
Responses Re: Design suggestion of multiple databases vs multiple schemas within the database
List pgsql-general
Tree view
I am building a web app with Postgres, that also uses Drupal with Postgres. I am new to all these frameworks.

There is some data that I'll need to cross-reference between the two databases.

Can I do a cross-schema/catalog join? Or is a cross-database join better?
Are there any gotchas for the cross-schema/cross-database joins that I need to be aware of? Such as when using Shared hosting?

Any suggestions/comments appreciated.

Thanks

pgsql-general by date:

Previous
From: "Swaminathan Saikumar"
Date:
Subject: Unicode comment on Postgres vs Sql Server
Next
From: Karl Denninger
Date:
Subject: 8.2.6 > 8.3 blows up