X-Original-To: pgsql-jdbc-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BFC323A43DA for ; Wed, 5 Jan 2005 17:29:59 +0000 (GMT) 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 91422-03 for ; Wed, 5 Jan 2005 17:29:43 +0000 (GMT) Received: by svr1.postgresql.org (Postfix, from userid 1001) id 337823A45FA; Wed, 5 Jan 2005 17:05:21 +0000 (GMT) Received: from mail63.csoft.net (leary3.csoft.net [63.111.22.74]) by svr1.postgresql.org (Postfix) with SMTP id B1EC23A498C for ; Wed, 5 Jan 2005 15:35:19 +0000 (GMT) Received: (qmail 17534 invoked by uid 1112); 5 Jan 2005 15:37:43 -0000 Date: Wed, 5 Jan 2005 10:37:42 -0500 (EST) From: Kris Jurka X-X-Sender: books@leary.csoft.net To: Dave Cramer Cc: deepthi@granwill.com, pgsql-jdbc@postgresql.org, pgsql-sql@postgresql.org Subject: Re: Calling a table in another database from plpgsql In-Reply-To: <41DBF01F.3090703@fastcrypt.com> Message-ID: References: <1104895845.41db5f6504e44@www.granwill.com> <41DBF01F.3090703@fastcrypt.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.014 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/20 X-Sequence-Number: 11900 On Wed, 5 Jan 2005, Dave Cramer wrote: > Kris is correct, this is a jdbc list, however to satisfy your curiosity, > you can't access data from another database. > You certainly can with dblink which is what his question was about. I didn't answer him because I remembered a recent off-topic question from him which I responded to with an answer and a suggestion of the appropriate list. As long as answers keep coming the hint will not be picked up. Kris Jurka