Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id A77109FB2FC for ; Thu, 9 Aug 2007 16:08:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 53854-06 for ; Thu, 9 Aug 2007 16:08:38 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.175]) by postgresql.org (Postfix) with ESMTP id 229439F94CC for ; Thu, 9 Aug 2007 16:08:37 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id a2so447037ugf for ; Thu, 09 Aug 2007 12:08:36 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=elLCheFZvHbCWJ+pRIjpOWh69I2ZbcpCDKz6DPnEdT1IP15n0KU+nOi18NLUcHc6//o5F8QcW2L4jntr7oeVCX4L8wJFknO7HAXg+an8ltwfzcmweZ5goEBVaoCygrnb6AF2RQiRknIAdSkEo6rhqQVtrmEBOJpa4UOq1RrRMuQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=AKQsBwui8nxKIEsm/WhiCTeJ7AQkctERim1g9SuuIc9JKVG9Kt944ay3JgggSIojrjxQlIi/44cTaaX+GotBfijlyzqrCU+ucZ0bHy3cgo+OOdeb8+bxr9smXyn3ITUDRCyJVThW3iLtLbxuCHPz8eASHKpodbfLBCtvH1l3zrY= Received: by 10.78.162.4 with SMTP id k4mr1035094hue.1186686515728; Thu, 09 Aug 2007 12:08:35 -0700 (PDT) Received: by 10.78.201.16 with HTTP; Thu, 9 Aug 2007 12:08:35 -0700 (PDT) Message-ID: <1d219a6f0708091208p6a17cafak83cb1d0beff4495d@mail.gmail.com> Date: Thu, 9 Aug 2007 15:08:35 -0400 From: "Chris Hoover" To: "Michael Goldner" Subject: Re: Joining tables in two different databases? Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_149895_13556714.1186686515695" References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/110 X-Sequence-Number: 26441 ------=_Part_149895_13556714.1186686515695 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On 8/8/07, Michael Goldner wrote: > > Is it possible to access tables in two different databases, running on > the > same server, from within psql? > Take a look at dblink in the contrib area. I think it will give you what you are looking for. Chris ------=_Part_149895_13556714.1186686515695 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On 8/8/07, Michael Goldner <MGoldner@agmednet.com> wrote:

Is it possible to access tables in two different databases, running on the
same server, from within psql?

Take a look at dblink in the contrib area.  I think it will give you what you are looking for.

Chris
------=_Part_149895_13556714.1186686515695--