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
>