Received: from sss.pgh.pa.us ([192.204.191.242])
	by postgresql.org (8.11.3/8.11.4) with ESMTP id fASFBBm79288
	for <pgsql-admin@postgresql.org>; Wed, 28 Nov 2001 10:11:11 -0500 (EST)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id fASFB5k02134;
	Wed, 28 Nov 2001 10:11:05 -0500 (EST)
To: Vincent.Gaboriau@answare.fr
cc: "'pgsql-admin@postgresql.org'" <pgsql-admin@postgresql.org>
Subject: Re: [HACKERS] upper and lower doesn't work with german 
In-reply-to: <3C04A23E.BF409D74@answare.fr> 
References: <20011127085555.A20745-100000@megazone23.bigpanda.com>
	<3C04A23E.BF409D74@answare.fr>
Comments: In-reply-to Vincent.Gaboriau@answare.fr
	message dated "Wed, 28 Nov 2001 09:37:18 +0100"
Date: Wed, 28 Nov 2001 10:11:05 -0500
Message-ID: <2131.1006960265@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Archive-Number: 200111/147
X-Sequence-Number: 2672

Vincent.Gaboriau@answare.fr writes:
>> You might be able to get it by looking through the
>> <data dir>/global/pg_control file, but it's a binary file so you'll have
>> to search for it.

> I had found it, but I don't know speak fluent binary language  ;-)
> Does a way exist to "decompile" it or to get informations on it?

If you can't be troubled to compile up pg_controldata, then you'll
have to resort to good old od:

$ od -c pg_control
0000000 314 201 030 267 255   u 344 277  \0  \0  \0   G 013 355   p 253
0000020  \0  \0  \0 004   < 004   ) 006  \0  \0  \0  \0  \0  \0  \0   8
0000040  \0  \0  \0  \0   7 026   e 210  \0  \0  \0  \0   7 026   D   h
0000060  \0  \0  \0  \0   7 026   e 210  \0  \0  \0  \0  \0  \0  \0  \0
0000100  \0  \0  \0  \t  \0 001 357 235  \0 017 017 354   < 004   ) 004
0000120  \0  \0      \0  \0 002  \0  \0   C  \0  \0  \0  \0  \0  \0  \0
0000140  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0
*
0000320  \0  \0  \0  \0  \0  \0  \0  \0   C  \0  \0  \0  \0  \0  \0  \0
0000340  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0
*
0020000

The LC_COLLATE and LC_CTYPE locale strings should be the last nonzero
things in the file --- they're both "C" in this example.

			regards, tom lane