query on two databases ..

From: "Muhammed Yazici" <yazici(at)chss(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: query on two databases ..
Date: 2001-05-30 07:23:56
Message-ID: 9f2765$1f9j$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message stone 2001-05-30 09:01:54 How to use the template table in postgresql
Previous Message Kapil Tilwani 2001-05-30 06:13:19 Re: [GENERAL]