> owner@xxxxxxxxxxxxxx] On Behalf Of Adrian Klaver > > 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 Thanks for the response, but this doesn't help. This is a standalone exe and it relies on the command line to find its own path. I need something that works in _PG_init(), which has no arguments passed in, and can only make calls to the C api. > 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. So what C api calls does that implementation make to find this information? > > 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 Yes, I'm familiar with all those. One possibility is to retrieve pg_proc.probin, which appears to always contain the relevant path. > > > > > Having got started it then needs to query the database. Is that OK > in > > _PG_init()? Regards David M Bennett FACS Andl - A New Database Language - andl.org -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
