Обсуждение: LC_CTYPE

Can someone tell me how I can check to see what my locale setting is for LC_CTYPE? is there a default setting if not specified during setup?
Thanks
Jodi

Jodi Kanter <jkanter@virginia.edu> writes:
> Can someone tell me how I can check to see what my locale setting is for
> LC_CTYPE?

pg_controldata will tell you.  (As of CVS tip you can just go "show
lc_ctype", but that's not in existing releases...)

            regards, tom lane

Tom
I am trying to select from pg_controldata but it does not seem to exist. Is this because I am running 7.2.3? How can I view all available system tables?
Thanks
Jodi

Tom Lane wrote:

Jodi Kanter <jkanter@virginia.edu> writes:

Can someone tell me how I can check to see what my locale setting is for 
LC_CTYPE?

pg_controldata will tell you.  (As of CVS tip you can just go "show
lc_ctype", but that's not in existing releases...)

			regards, tom lane

Jodi Kanter <jkanter@virginia.edu> writes:
> I am trying to select from pg_controldata but it does not seem to exist.

Sorry --- it's a program not a table.  In 7.2 I believe it's in contrib.

            regards, tom lane

Jodi Kanter wrote:

> Tom
> I am trying to select from pg_controldata but it does not seem to
> exist. Is this because I am running 7.2.3? How can I view all
> available system tables?
> Thanks
> Jodi
>
> Tom Lane wrote:
>
>>Jodi Kanter <jkanter@virginia.edu> writes:
>>
>>
>>>Can someone tell me how I can check to see what my locale setting is for
>>>LC_CTYPE?
>>>
>>>
>>
>>pg_controldata will tell you.  (As of CVS tip you can just go "show
>>lc_ctype", but that's not in existing releases...)
>>
>>            regards, tom lane
>>
>>
>
> --
>
> / _______________________________
> //Jodi L Kanter
> BioInformatics Database Administrator
> University of Virginia
> (434) 924-2846
> jkanter@virginia.edu <mailto:jkanter@virginia.edu> /
>
>
>
> /  /
>
> /  /
>
>
pg_controldata is not a system table but an Unix command provided by
PostgreSQL. See man pg_controledata.

--
Jean-Michel Chabanne
77450 MONTRY (FRANCE)
48" 54' N - 2" 49' E
Powered by Linux