From: | "Muhammed Yazici" <yazici(at)chss(dot)net> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: query on two databases .. |
Date: | 2001-06-01 07:41:06 |
Message-ID: | 9f7guc$cve$1@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
...sh*
But thanx ..
i'll try another solution ..
"Nils Zonneveld" <nils(at)mbit(dot)nl> schrieb im Newsbeitrag
news:3B151F78(dot)D30560BE(at)mbit(dot)nl(dot)(dot)(dot)
>
>
> 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 ..
> >
> > m. Yazici
> > yazici(at)chss(dot)net
>
> While schema's have not (yet) been implemented, it's not possible to
> refer to two database in one SQL statement in PostgreSQL.
>
> Regards,
>
> Nils
From | Date | Subject | |
---|---|---|---|
Next Message | David BOURIAUD | 2001-06-01 13:52:31 | Problem with pg_index. |
Previous Message | Gerald Gutierrez | 2001-05-31 23:26:33 | RE: primary key scans in sequence |