Re: Get Postgre Status and Information - Mailing list 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