Multidatabase query - Mailing list pgsql-general

From Mauro Bertoli
Subject Multidatabase query
Date
Msg-id 670516.99459.qm@web24402.mail.ird.yahoo.com
Whole thread Raw
Responses Re: Multidatabase query  (Vibhor Kumar <vibhor.aim@gmail.com>)
Re: Multidatabase query  (Neanderthelle Jones <elle@view.net.au>)
List pgsql-general
Hi all,
is possible in PostgreSQL to create query between multidatabase like Sql Server 2005?

An example:
SELECT
  db1.a.id FROM db1.a
UNION
  db2.b.id FROM db2.b

Where "db1" is a database and "db2" is another database. "a" is a table in database "db1" and "b" is a table in
database"db2" 

Best regards,
Mauro




pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: Postgresql On Windows
Next
From: Justin Funk
Date:
Subject: Partitioned tabled not using indexes for full text search