Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f55JOsE58752 for ; Tue, 5 Jun 2001 15:24:54 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4UGS9E56451 for ; Wed, 30 May 2001 12:28:09 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f4UGRvp54568 for pgsql-sql@postgresql.org; Wed, 30 May 2001 12:27:57 -0400 (EDT) (envelope-from news) From: Nils Zonneveld X-Newsgroups: comp.databases.postgresql.sql Subject: Re: query on two databases .. Date: Wed, 30 May 2001 18:27:55 +0200 Organization: Nilsies little old network Lines: 33 Message-ID: <3B151F78.D30560BE@mbit.nl> References: <9f2765$1f9j$1@news.tht.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@cistron.nl X-Mailer: Mozilla 4.75 (Macintosh; U; PPC) X-Accept-Language: nl,en To: pgsql-sql@postgresql.org X-Archive-Number: 200106/43 X-Sequence-Number: 3255 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@chss.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