Re: Built in function question - Mailing list pgsql-general

From Joe Conway
Subject Re: Built in function question
Date
Msg-id 4369AAC2.1090204@joeconway.com
Whole thread Raw
In response to Re: Built in function question  (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
List pgsql-general
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
---------------------------
  /usr/local/pgsql-8.0/data
(1 row)

Joe

pgsql-general by date:

Previous
From: "Venki"
Date:
Subject: Re: Disappearing Records
Next
From: Michael Fuhr
Date:
Subject: Re: Problem with array in plpgsql function .. please help :-)