Обсуждение: How to get dow in Hungarian?

Hi,

I have installed PostgreSQL 9.1.4 on my Debian GNU/Linux testing/sid
system.

I have on it the 'iskolanaptar_201213' database and in it the
'az_1_felev_kezdete_vege_es_napok_szama' view.

I can run this view on the psql prompt:
iskolanaptar_201213=#

CREATE OR REPLACE VIEW az_1_felev_kezdete_vege_es_napok_szama \
AS SELECT felevek_kezdetei_1_8.datum AS "Az 1. félév kezdete,",\
 to_char(felevek_kezdetei_1_8.datum, 'day') AS "a első nap", \
felev1_vege_tan_nap_1_8.datum AS "a félév vége,", \
to_char(felev1_vege_tan_nap_1_8.datum, 'day') \
AS "az utolsó nap", felev1_vege_tan_nap_1_8.ennyi_tan_nap \
AS "és a napok száma a félévben minden osztálynak." \
FROM felev1_vege_tan_nap_1_8, felevek_kezdetei_1_8 \
WHERE felevek_kezdetei_1_8.felev1v2 = '1';
CREATE VIEW


and get the output by running:
select * from az_1_felev_kezdete_vege_es_napok_szama;

 Az 1. félév kezdete, | az első nap | a félév vége, | az utolsó nap | és a napok száma a félévben minden osztálynak.
----------------------+-------------+---------------+---------------+------------------------------------------------
 2012-09-03           | monday      | 2012-12-21    | friday        |                                             78
(1 row)

How can I get the day name say 'monday' not in English but in Hungarian?

--
Regards from Pal

Csanyi Pal <csanyipal@gmail.com> writes:
> How can I get the day name say 'monday' not in English but in Hungarian?

The documentation for to_char suggests that you need to say "tmday"
not just "day" to get a translated day name.  You might also need to
fool with your LC_TIME setting.

            regards, tom lane

Tom Lane <tgl@sss.pgh.pa.us> writes:

> Csanyi Pal <csanyipal@gmail.com> writes:
>> How can I get the day name say 'monday' not in English but in
>Hungarian?
>
> The documentation for to_char suggests that you need to say "tmday"
> not just "day" to get a translated day name.

It works!!

> You might also need to fool with your LC_TIME setting.

I have already these settings.

$ locale

LANG=hu_HU.UTF-8
LANGUAGE=
LC_CTYPE="hu_HU.UTF-8"
LC_NUMERIC="hu_HU.UTF-8"
LC_TIME="hu_HU.UTF-8"
LC_COLLATE="hu_HU.UTF-8"
LC_MONETARY="hu_HU.UTF-8"
LC_MESSAGES="hu_HU.UTF-8"
LC_PAPER="hu_HU.UTF-8"
LC_NAME="hu_HU.UTF-8"
LC_ADDRESS="hu_HU.UTF-8"
LC_TELEPHONE="hu_HU.UTF-8"
LC_MEASUREMENT="hu_HU.UTF-8"
LC_IDENTIFICATION="hu_HU.UTF-8"
LC_ALL=

--
Regards from Pal