Postgres Pro
Downloads
Home   >   mailing lists

Re: Querying two databases - Mailing list pgsql-sql

From Rajesh Kumar Mallah
Subject Re: Querying two databases
Date
Msg-id 408027DE.1070307@trade-india.com
Whole thread Raw
In response to Querying two databases  (Pallav Kalva <pkalva@deg.cc>)
List pgsql-sql
Tree view 

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
>

pgsql-sql by date:

Previous
From: Pallav Kalva
Date:
Subject: Querying two databases
Next
From: "Yudie"
Date:
Subject: Re: Update is very slow on a bigger table