Design suggestion of multiple databases vs multiple schemas within the database

From: "Swaminathan Saikumar" <swami(at)giveexam(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Design suggestion of multiple databases vs multiple schemas within the database
Date: 2008-03-02 19:54:03
Message-ID: 82692d4a0803021154r4c9fd44fh26b7021db8153d23@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-03-02 20:12:39 Re: Design suggestion of multiple databases vs multiple schemas within the database
Previous Message Swaminathan Saikumar 2008-03-02 19:50:01 Unicode comment on Postgres vs Sql Server