Re: db cluster location - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: db cluster location
Date
Msg-id hja7lj$c4v$1@ger.gmane.org
Whole thread Raw
In response to db cluster location  (Scott Frankel <frankel@circlesfx.com>)
Responses Re: db cluster location  (Scott Frankel <frankel@circlesfx.com>)
List pgsql-general
Scott Frankel wrote on 21.01.2010 18:34:
>
> Hi all,
>
> Is there a query I can use to find the location of a db cluster?

SELECT name,
        setting
FROM pg_settings
WHERE category = 'File Locations';

You need to be connected as the superuser (usually postgres)


pgsql-general by date:

Previous
From: Kynn Jones
Date:
Subject: PgSQL problem: How to split strings into rows
Next
From: Thomas Kellerer
Date:
Subject: Re: PgSQL problem: How to split strings into rows