| Lists: | pgsql-admin |
|---|
| From: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
|---|---|
| To: | Postgres Admin List <pgsql-admin(at)postgresql(dot)org> |
| Subject: | LC_CTYPE |
| Date: | 2003-04-30 14:56:32 |
| Message-ID: | 3EAFE420.40304@virginia.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
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 L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter(at)virginia(dot)edu <mailto:jkanter(at)virginia(dot)edu>
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
| Cc: | Postgres Admin List <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: LC_CTYPE |
| Date: | 2003-04-30 14:56:34 |
| Message-ID: | 22215.1051714594@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
Jodi Kanter <jkanter(at)virginia(dot)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
| From: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
|---|---|
| To: | Postgres Admin List <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: LC_CTYPE |
| Date: | 2003-04-30 17:46:55 |
| Message-ID: | 3EB00C0F.50908@virginia.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
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(at)virginia(dot)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(at)virginia(dot)edu <mailto:jkanter(at)virginia(dot)edu>
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
| Cc: | Postgres Admin List <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: LC_CTYPE |
| Date: | 2003-05-01 00:15:16 |
| Message-ID: | 25322.1051748116@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
Jodi Kanter <jkanter(at)virginia(dot)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
| From: | Jean-Michel Chabanne <jeanmichel(dot)chabanne(at)free(dot)fr> |
|---|---|
| To: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
| Cc: | Postgres Admin List <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: LC_CTYPE |
| Date: | 2003-05-01 06:14:31 |
| Message-ID: | 3EB0BB47.9040502@free.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
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(at)virginia(dot)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(at)virginia(dot)edu <mailto:jkanter(at)virginia(dot)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