Re: Querying two databases

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
>