Thread: Querying two databases

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
>