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