On 03/10/2016 05:24 AM, david@xxxxxxxx wrote:
My language handler requires some configuration information to start up,
which I would like to get from the file system (but it could be set up
by an SQL query SET). Currently I’m using hard-coded paths, which
doesn’t seem like a good solution. Is there perhaps a way to get the
path that was used to load the DLL? I couldn’t find one in the existing
language implementations.
There is pg_config:
http://www.postgresql.org/docs/9.5/interactive/app-pgconfig.html
At the moment it is only available from the above command. In 9.6:
http://www.depesz.com/2016/02/29/waiting-for-9-6-add-new-system-view-pg_config/
it also be available in a system view.
There are the following systems catalogs that give you information about
languages:
http://www.postgresql.org/docs/9.5/interactive/catalog-pg-language.html
http://www.postgresql.org/docs/9.5/interactive/catalog-pg-pltemplate.html
http://www.postgresql.org/docs/9.5/interactive/catalog-pg-proc.html
Having got started it then needs to query the database. Is that OK in
_PG_init()?
Any hints much appreciated.
Regards
David M Bennett FACS
/
------------------------------------------------------------------------
/
/Andl - A New Database Language - andl.org/
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
