| From: | "Anthony E (dot) Greene" <agreene(at)pobox(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: PostgresQL Connection Question |
| Date: | 2000-09-27 12:21:51 |
| Message-ID: | 20000927082151.C4627@cp5340 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, 21 Sep 2000 17:58 Gavin M. Roy wrote:
>Is it possible in one sql statement to query tables from multiple
>databases?
No. The query is sent to the backend over a connection to a specific
database. You will need to create separate queries for each database and send the
appropriate query to each one.
It's not too hard. There is more error checking involved, but I had to do
it in one of my applications and found that it's not much more trouble.
--
Anthony E. Greene <agreene(at)pobox(dot)com> <http://www.pobox.com/~agreene/>
PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26 C484 A42A 60DD 6C94 239D
AIM: TonyG05 ICQ: 91183266 Jabber: TonyGreene
Linux. The choice of a GNU Generation. <http://www.linux.org/>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hernandez Alvarez Alfredo | 2000-09-29 14:47:58 | Vacuum error |
| Previous Message | Loïc TREGOUËT | 2000-09-27 09:11:38 | security , multiple interface |