pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedQuerying two databases
2+ messages / 2 participants
[nested] [flat]
* Querying two databases
@ 2004-04-16 18:02 Pallav Kalva <pkalva@deg.cc>
0 siblings, 1 reply; 2+ messages in thread
From: Pallav Kalva @ 2004-04-16 18:02 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Querying two databases
@ 2004-04-16 18:37 Rajesh Kumar Mallah <mallah@trade-india.com>
parent: Pallav Kalva <pkalva@deg.cc>
0 siblings, 0 replies; 2+ messages in thread
From: Rajesh Kumar Mallah @ 2004-04-16 18:37 UTC (permalink / raw)
To: Pallav Kalva <pkalva@deg.cc>; +Cc: pgsql-sql
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
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-04-16 18:37 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-04-16 18:02 Querying two databases Pallav Kalva <pkalva@deg.cc>
2004-04-16 18:37 ` Rajesh Kumar Mallah <mallah@trade-india.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox