pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedQuery from different Database
3+ messages / 3 participants
[nested] [flat]
* Query from different Database
@ 2004-10-07 08:52 Abdul Wahab Dahalan <wahab@mimos.my>
0 siblings, 1 reply; 3+ messages in thread
From: Abdul Wahab Dahalan @ 2004-10-07 08:52 UTC (permalink / raw)
To: pgsql-sql
I'm looking for a solution to make a query from two different databases. If anybody has an experience or know how to solve it, please help me. Thanks.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Query from different Database
@ 2004-10-07 14:05 Robert Creager <Robert_Creager@LogicalChaos.org>
parent: Abdul Wahab Dahalan <wahab@mimos.my>
0 siblings, 1 reply; 3+ messages in thread
From: Robert Creager @ 2004-10-07 14:05 UTC (permalink / raw)
To: Abdul Wahab Dahalan <wahab@mimos.my>; pgsql-sql
When grilled further on (Thu, 7 Oct 2004 16:52:38 +0800 (MYT)),
Abdul Wahab Dahalan <wahab@mimos.my> confessed:
> I'm looking for a solution to make a query from two different databases. If
> anybody has an experience or know how to solve it, please help me. Thanks.
>
I believe that the contrib module dblink will do what you want, but I've never
used it.
Cheers,
Rob
--
08:01:41 up 14 days, 10:28, 2 users, load average: 3.27, 2.64, 2.34
Linux 2.6.5-02 #8 SMP Mon Jul 12 21:34:44 MDT 2004
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Query from different Database
@ 2004-10-07 20:58 Jaime Casanova <systemguards@yahoo.com>
parent: Robert Creager <Robert_Creager@LogicalChaos.org>
0 siblings, 0 replies; 3+ messages in thread
From: Jaime Casanova @ 2004-10-07 20:58 UTC (permalink / raw)
To: pgsql-sql
--- Robert Creager <Robert_Creager@LogicalChaos.org>
escribió:
> When grilled further on (Thu, 7 Oct 2004 16:52:38
> +0800 (MYT)),
> Abdul Wahab Dahalan <wahab@mimos.my> confessed:
>
> > I'm looking for a solution to make a query from
> two different databases. If
> > anybody has an experience or know how to solve it,
> please help me. Thanks.
> >
>
> I believe that the contrib module dblink will do
> what you want, but I've never
> used it.
>
What about using schemas not databases. Selects
between schemas are fully supported.
Regards,
Jaime Casanova
_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-10-07 20:58 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-07 08:52 Query from different Database Abdul Wahab Dahalan <wahab@mimos.my>
2004-10-07 14:05 ` Robert Creager <Robert_Creager@LogicalChaos.org>
2004-10-07 20:58 ` Jaime Casanova <systemguards@yahoo.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