hi,
its not possible to join cross database tables . you may keep tables in different schemas instead of databases.
you may also try contrib/dblink to use tables from different database.
Regds mallah.
Pallav Kalva wrote:
Hi,
I am new to postgres and I need to do a query which joins two tables from different databases. Can you please advice me on how to achieve this in postgres.
Thanks! Pallav
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
