X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 817BE32A255 for ; Thu, 7 Oct 2004 15:06:08 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 71944-06 for ; Thu, 7 Oct 2004 14:05:58 +0000 (GMT) Received: from rambo.iniquinet.com (rambo.iniquinet.com [69.39.89.10]) by svr1.postgresql.org (Postfix) with ESMTP id 38BA532A3CF for ; Thu, 7 Oct 2004 15:05:59 +0100 (BST) Received: (qmail 18102 invoked by uid 1010); 7 Oct 2004 10:05:59 -0400 Received: from Robert_Creager@LogicalChaos.org by rambo.iniquinet.com by uid 1002 with qmail-scanner-1.20 (clamscan: 0.70. spamassassin: 2.64. Clear:RC:0(216.150.208.13):SA:0(-4.5/6.0):. Processed in 1.343107 secs); 07 Oct 2004 14:05:59 -0000 Received: from static-13.mm.den.viawest.net (HELO thunder.mshome.net) (perl?test@logicalchaos.org@216.150.208.13) by rambo.iniquinet.com with AES256-SHA encrypted SMTP; 7 Oct 2004 10:05:58 -0400 Received: from localhost.localdomain (thunder.mshome.net [192.168.0.250]) by thunder.mshome.net (Postfix) with ESMTP id 06057579B; Thu, 7 Oct 2004 08:05:57 -0600 (MDT) Received: from logicalchaos.org (thunder.mshome.net [192.168.0.250]) by thunder.mshome.net (Postfix) with SMTP id EEE0757B8; Thu, 7 Oct 2004 08:05:52 -0600 (MDT) Date: Thu, 7 Oct 2004 08:05:46 -0600 From: Robert Creager To: Abdul Wahab Dahalan , pgsql-sql@postgresql.org Subject: Re: Query from different Database Message-ID: <20041007080546.129d89a9@thunder.mshome.net> In-Reply-To: <153694.1097139158453.SLOX.WebMail.wwwrun@openx.mimos.my> References: <153694.1097139158453.SLOX.WebMail.wwwrun@openx.mimos.my> Organization: Starlight Vision, LLC. X-Mailer: Sylpheed-Claws 0.9.12a (GTK+ 1.2.10; i586-mandrake-linux-gnu) Mime-Version: 1.0 Content-Type: multipart/signed; protocol="application/pgp-signature"; micalg="pgp-sha1"; boundary="Signature=_Thu__7_Oct_2004_08_05_47_-0600_JEmh9JYbC.qWJSK5" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/43 X-Sequence-Number: 19146 --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 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 --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+9I7vfTRw1MFcJ2PrOA TRIAoJRp4eSiadyPqPH2sEVxMeWOrGe2 =RppW -----END PGP SIGNATURE----- --Signature=_Thu__7_Oct_2004_08_05_47_-0600_JEmh9JYbC.qWJSK5--