X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 7C5439FB259 for ; Thu, 17 Aug 2006 18:14:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 96393-02 for ; Thu, 17 Aug 2006 21:14:10 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.175]) by postgresql.org (Postfix) with ESMTP id AA1DD9FB251 for ; Thu, 17 Aug 2006 18:14:09 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id m3so668010ugc for ; Thu, 17 Aug 2006 14:14:08 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=cFOsgrVHo0nBeU29PLe0Hg80zz0IYHaI7TUcWCeaONWoLs6xi7avsLfUxW/z9rmiOcsPm9Fj0RyQEa7I6tHQeuTm6q6ZFgIztZPlhWz9MaZu03wl4qnnODqtGDi6zAxYkuJpI1hQ5H2ITksiMR8vFLqfDcz3Bc/G8XKlxGwOPnk= Received: by 10.67.97.7 with SMTP id z7mr1434968ugl; Thu, 17 Aug 2006 14:14:08 -0700 (PDT) Received: by 10.66.248.13 with HTTP; Thu, 17 Aug 2006 14:14:08 -0700 (PDT) Message-ID: <7539aebb0608171414v53cfa029se542c659fb05e438@mail.gmail.com> Date: Thu, 17 Aug 2006 17:14:08 -0400 From: Sumeet To: "Michael Fuhr" Subject: Re: About DBlink Cc: pgsql-sql@postgresql.org In-Reply-To: <20060817205958.GA92552@winnie.fuhr.org> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_34638_22311179.1155849248298" References: <7539aebb0608171337q4be69d76l82fff2b7bdf122f6@mail.gmail.com> <20060817205958.GA92552@winnie.fuhr.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.2 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/138 X-Sequence-Number: 26096 ------=_Part_34638_22311179.1155849248298 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Thanks Micheal I dont have dblink installed, I need to find a good documentation which will help me do this and also the place where i can download this module. Thanks, Sumeet. On 8/17/06, Michael Fuhr wrote: > > On Thu, Aug 17, 2006 at 04:37:03PM -0400, Sumeet wrote: > > Im trying to find out documentation for postgres module names "dblink", > can > > anyone point me out to it. What i want to do is join multiple databases > > instead of multiple tables. > > If you've installed dblink then somewhere on your system should be > a file named README.dblink. How to find that file depends on the > platform: on many Unix-like systems you can use "locate" or "find", > or if you installed dblink via a package then you could use the > package management tool to display a list of files that it installed. > > I'd mention that doing joins between databases isn't a good idea > but it looks like you've already had that discussion in the recent > "Multiple DB join" thread. > > http://archives.postgresql.org/pgsql-sql/2006-08/msg00097.php > > -- > Michael Fuhr > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > -- Thanks, Sumeet Ambre Masters of Information Science Candidate, Indiana University. ------=_Part_34638_22311179.1155849248298 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Thanks Micheal I dont have dblink installed, I need to find a good documentation which will help me do this and also the place where i can download this module.

Thanks,
Sumeet.

On 8/17/06, Michael Fuhr <mike@fuhr.org> wrote:
On Thu, Aug 17, 2006 at 04:37:03PM -0400, Sumeet wrote:
> Im trying to find out documentation for postgres module names "dblink", can
> anyone point me out to it. What i want to do is join multiple databases
> instead of multiple tables.

If you've installed dblink then somewhere on your system should be
a file named README.dblink.  How to find that file depends on the
platform: on many Unix-like systems you can use "locate" or "find",
or if you installed dblink via a package then you could use the
package management tool to display a list of files that it installed.

I'd mention that doing joins between databases isn't a good idea
but it looks like you've already had that discussion in the recent
"Multiple DB join" thread.

http://archives.postgresql.org/pgsql-sql/2006-08/msg00097.php

--
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings



--
Thanks,
Sumeet Ambre
Masters of Information Science Candidate,
Indiana University. ------=_Part_34638_22311179.1155849248298--