Thread: connecting inside pl/pgsql

Is there any way to connect to a different database inside a pl/pgsql
function? Apparently, this is possible in Oracle PL/SQL, and it would be
useful for porting that code.

If it is not possible, are there any plans to add this?

-Edwin

On Monday 16 Sep 2002 10:45 pm, Edwin Grubbs wrote:
> Is there any way to connect to a different database inside a pl/pgsql
> function? Apparently, this is possible in Oracle PL/SQL, and it would be
> useful for porting that code.
>
> If it is not possible, are there any plans to add this?

You should investigate the contrib/dblink directory in the source
distribution.

- Richard Huxton

Richard Huxton wrote:
>
> On Monday 16 Sep 2002 10:45 pm, Edwin Grubbs wrote:
> > Is there any way to connect to a different database inside a pl/pgsql
> > function? Apparently, this is possible in Oracle PL/SQL, and it would be
> > useful for porting that code.
> >
> > If it is not possible, are there any plans to add this?
>
> You should investigate the contrib/dblink directory in the source
> distribution.

It is possible in PL/TclU. There are currently no plans to add it
to PL/pgSQL.


Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being
right. #
# Let's break this rule - forgive
me.                                  #
#==================================================
JanWieck@Yahoo.com #