On Fri, Jun 9, 2017 at 3:05 AM, Heikki Linnakangas <hlinn...@iki.fi> wrote:
> On 06/09/2017 08:56 AM, Supun Nakandala wrote:
>> Hi hackers,
>> I am trying to extend PostgreSQL by adding UDT and UDF for a custom use
>> case and I am using C language extensions to do that.
>> However, I have a requirement of reading a text file from one of the C
>> functions. The compiled *.so files are placed in the "pg_config
>> --pkglibdir" directory and tried copying my text files there but it didn't
>> work. I found that, when these shared libs are loaded they are run from a
>> different working directory. In this case, what is the best way to refer
>> my text files from the C code other than giving the absolute path which
>> change from system to system.
> All backend processes run with the data directory as the current
> directory. So you can put the files into the data directory, probably best
> to have a subdirectory there to avoid confusing them with PostgreSQL's own
> files. Or you could have a config option, to set an absolute path.
> - Heikki
Thank you everyone for your quick replies. I ended up copying the files to
the data directory and referring using relative path.