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);
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