Re: Multidatabase query

Hi Mauro,

Not possible in PostgreSQL.

However, you can use dblink for creating query between multidatabase as
given below:

select empno from dblink('dbname=edb','SELECT empno from emp') as
emp(empno numeric)
union
select empno from dblink('dbname=enterprisedb','SELECT empno from emp')
as emp(empno numeric);

where edb and enterprisedb are database names

For More information about dblink, please follow the link given below:
http://www.postgresql.org/docs/current/static/dblink.html
http://www.enterprisedb.com/docs/en/8.3/oracompat/EnterpriseDB_OraCompat_EN_8.3-49.htm

Regards,
Vibhor Kumar
www.enterprisedb.com

Mauro Bertoli wrote:
> 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
>
>
>
>
>