Re: Get Postgre Status and Information

From: dom(at)happygiraffe(dot)net (Dominic Mitchell)
To: "m(dot)b(dot)" <vvjy2k(at)gmx(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Get Postgre Status and Information
Date: 2004-10-11 08:40:01
Message-ID: 20041011084001.GA63209@ppe.happygiraffe.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Oct 11, 2004 at 10:04:09AM +0200, m.b. wrote:
> is there a possibility to get some useful information about
> my postgresql installation, its configuration, the locales
> and information about the databases which run on the system ?
> so i would be able to compare 3 different systems and see
> the difference between them from postgres's view

Try doing "SELECT * FROM pg_settings". That should give you most of the
information you need.

-Dom

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Armen Rizal 2004-10-11 09:05:39 Reusable pl/pgsql samples ?
Previous Message Sim Zacks 2004-10-11 08:39:03 update sequence conversion script