Re: Built in function question

From: Joe Conway <mail(at)joeconway(dot)com>
To: tony_caduto(at)amsoftwaredesign(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Built in function question
Date: 2005-11-03 06:14:26
Message-ID: 4369AAC2.1090204@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-11-03 09:09:50 Re: Problem with array in plpgsql function .. please help :-)
Previous Message Venki 2005-11-03 06:00:33 Re: Disappearing Records