Utility program to read parameters of the current database - Mailing list pgsql-hackers

From Oliver Elphick
Subject Utility program to read parameters of the current database
Date
Msg-id 200102072136.f17LaVw07492@linda.lfix.co.uk
Whole thread Raw
Responses Re: Utility program to read parameters of the current database  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
I had a need to read such things as the backend locale and the catalog
version number from the current database, and couldn't find any existing
program to do that.

The attached utility produces this output:

linda:~$ pg_controldata
Log file id:                          0
Log file segment:                     5
Last modified:                        Wed Feb  7 19:35:47 2001
Database block size:                  8192
Blocks per segment of large relation: 131072
Catalog version number:               200101061
LC_COLLATE:                           en_GB
LC_CTYPE:                             en_GB
Log archive directory:


Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "But the LORD is in his holy temple; let all the earth
      keep silence before him."           Habakkuk 2:20
Attachment

pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: a contrib function to query current locale values
Next
From: Tom Lane
Date:
Subject: Re: [INTERFACES] pgAccess fails to launch on HPUX