| From: | Nabil Sayegh <postgresql(at)e-trolley(dot)de> |
|---|---|
| To: | "Wayne M(dot) Syvinski" <matthew(at)techcelsior(dot)com> |
| Cc: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: a: queries across databases b: plperl |
| Date: | 2003-08-17 20:47:17 |
| Message-ID: | 1061153237.601.18.camel@billy |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Am Son, 2003-08-17 um 22.10 schrieb Wayne M. Syvinski:
> A. I read in one of my PostgreSQL books that you cannot execute queries
> across databases. What I have are several lookup tables that I need to
If you really _have_ to query across databases, you could use dblink
(it's in the contribs).
If the databases are on the same machine, you should merge them together
in one big databse.
With SCHEMA you can have multiple 'virtual' databases in one db.
All have their own namespace, so every SCHEMA can have tables with the
same tablenames as other SCHEMA.
With SCHEMA you can have REFERENTIAL INTEGRITY across the 'virtual
databases' and other goodies :)
> Any help is greatly appreciated
done
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Warwick Hunter | 2003-08-17 22:51:24 | Re: Large object - what's happening? |
| Previous Message | Wayne M. Syvinski | 2003-08-17 20:10:56 | a: queries across databases b: plperl |