Re: pltcl and modules question

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pltcl and modules question
Date: 2013-03-27 14:40:13
Message-ID: 9aa0674a515d5de5cb1f2301e40da3db@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)turnstep(dot)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-----

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message CR Lender 2013-03-27 14:43:34 Re: pg_stat_get_last_vacuum_time(): why non-FULL?
Previous Message Tom Lane 2013-03-27 14:03:12 Re: Understanding behavior of SELECT with multiple unnested columns