Re: Calling a table in another database from plpgsql

From: Kris Jurka <books(at)ejurka(dot)com>
To: Dave Cramer <pg(at)fastcrypt(dot)com>
Cc: deepthi(at)granwill(dot)com, pgsql-jdbc(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: Calling a table in another database from plpgsql
Date: 2005-01-05 15:37:42
Message-ID: Pine.BSO.4.56.0501051020590.3026@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc pgsql-sql

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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2005-01-05 15:56:09 Re: Update: jdbc-tr.po
Previous Message Dave Cramer 2005-01-05 13:48:15 Re: Calling a table in another database from plpgsql

Browse pgsql-sql by date

  From Date Subject
Next Message Kretschmer Andreas 2005-01-05 16:28:37 Re: Calling a table residing in another database from Plpgsql
Previous Message Joe Conway 2005-01-05 14:54:08 Re: Calling a table residing in another database from Plpgsql