Re: [SQL] query on two databases ..

2001-06-05 Thread Stephan Szabo
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 > d

[SQL] query on two databases ..

2001-06-05 Thread Muhammed Yazici
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"