Re: pltcl and modules question - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: pltcl and modules question
Date
Msg-id 9aa0674a515d5de5cb1f2301e40da3db@biglumber.com
Whole thread Raw
In response to pltcl and modules question  (hamann.w@t-online.de)
Responses Re: pltcl and modules question
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


> is there any way to use a module within a pltcl script, i.e. have
> load /path/to/mystuff.so
> or
> package require mystuff
> in a script.

You can load tcl code by putting it in the pltcl_modules tables. See:

http://www.postgresql.org/docs/9.2/static/pltcl-unknown.html

> Similarly, would it be possible to access loaded module from perl
> script, i.e. have
> use mystuff;

You can load any Perl module you want within a Pl/PerlU function.

It's possible to access shared code with Pl/Perl, but it's a little
more involved. See:

http://www.postgresql.org/docs/9.2/static/plperl-under-the-hood.html

- --
Greg Sabino Mullane greg@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201303271036
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAlFTBHcACgkQvJuQZxSWSsiDogCdHga7xxBEVJFSEKlJqME+uo0o
pykAnicK1fLKZOJZMN2j1iEKQr4+AQMk
=b3/1
-----END PGP SIGNATURE-----




pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Understanding behavior of SELECT with multiple unnested columns
Next
From: CR Lender
Date:
Subject: Re: pg_stat_get_last_vacuum_time(): why non-FULL?