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.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
--Signature=_Thu__7_Oct_2004_08_05_47_-0600_JEmh9JYbC.qWJSK5
Content-Type: text/plain; charset=US-ASCII
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
When grilled further on (Thu, 7 Oct 2004 16:52:38 +0800 (MYT)),
Abdul Wahab Dahalan
> 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
--Signature=_Thu__7_Oct_2004_08_05_47_-0600_JEmh9JYbC.qWJSK5
Content-Type: application/pgp-signature
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
iEYEARECAAYFAkFlTUAACgkQLQ/DKuwDYzl/hACdEDrpH+9I7vfTRw1MFcJ2 PrOA
TRIAoJRp4eSiadyPqPH2sEVxMeWOrGe2
=RppW
-----END PGP SIGNATURE-----
--Signature=_Thu__7_Oct_2004_08_05_47_-0600_JEmh9JYbC.qWJSK5 --
--- Robert Creager
escribió:
> When grilled further on (Thu, 7 Oct 2004 16:52:38
> +0800 (MYT)),
> Abdul Wahab Dahalan
>
> > 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match