Re: [GENERAL] Built in function question

2005-11-02 Thread Joe Conway
Tony Caduto wrote: [question about finding data directory] I found it in the pg_settings view, but if there is another way I would like to know about it. As Tom aluded, you can also do this: regression=# select current_setting('data_directory'); current_setting --

Re: [GENERAL] Built in function question

2005-11-02 Thread Tom Lane
Tony Caduto <[EMAIL PROTECTED]> writes: > Does anyone know if there is a function that can return the path to the > data directory? In 8.0 and later, SHOW data_directory; or the equivalent function call. regards, tom lane ---(end of broadc

Re: [GENERAL] Built in function question

2005-11-02 Thread Tony Caduto
I found it in the pg_settings view, but if there is another way I would like to know about it. Thanks, Tony Tony Caduto wrote: Does anyone know if there is a function that can return the path to the data directory? I was looking through the docs, but could not find anything. Thanks, --