From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | Muhammed Yazici <yazici(at)chss(dot)net> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: query on two databases .. |
Date: | 2001-06-05 21:30:38 |
Message-ID: | Pine.BSF.4.21.0106051430030.11232-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
There is currently no ability to span databases in a single
query.
On Wed, 30 May 2001, Muhammed Yazici wrote:
> hi,
> i'am really new to postgresql and i try it with php ..
>
> Now i have following question :
>
> is it possible to make one query on two databases. I have a database calles
> db1 and one db2 and i want to get :
>
>
> select * from ":db1:table1" where ":db1:table1:col1" in (select "col1" from
> ":db2:table1" );
>
> (this query will work in interbase dbs)
>
> how is the right syntax in postgresql ??
>
> can anybody help my .. i looked in diffent manuals but i couldnt find the
> syntax ..
>
> thanks a lot for your help in forward ..
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2001-06-05 21:33:43 | Re: 7.1 LOCK TABLE changes |
Previous Message | Stephan Szabo | 2001-06-05 21:14:19 | Re: Distinct Values |