| From: | Mike Rylander <miker(at)purplefrog(dot)com> |
|---|---|
| To: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
| Subject: | Re: cross databases? |
| Date: | 2004-07-08 15:55:31 |
| Message-ID: | ccjroc$13bl$1@news.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
<posted & mailed>
Jodi Kanter wrote:
> I am working with someone who uses MySQL and says that he has two
> separate databases in which he can query across. I am curious if that is
> something that can be done in postgres?
Postgresql implements SQL standard SCHEMAs which, depending on your exact
needs, may serve the same purpose. The other option is the
'contrib/dblink' module.
> Any comments on whether or not that is a good thing?
In my opinion, SCHEMAs are a beter way than multiple databases to deal with
multiple logical datasets that you want to query across.
--miker
> Thanks
> Jodi Kanter
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Elphick | 2004-07-08 16:00:49 | Re: cross databases? |
| Previous Message | Sarah Tanembaum | 2004-07-08 15:49:36 | Secure DB Systems - How to |