Welcome to psql 8.3.0, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit Warning: Console code page (437) differs from Windows code page (1252) 8-bit characters might not work correctly. See psql reference page "Notes for Windows users" for details. Gevik=# set lc_messages to 'sv_SE'; SET Gevik=# select to_char((current_date + s.a),'TMDay TMMonth YYYY') as dates from generate_series(0,6) as s(a); dates ----------------------- Torsdag Februari 2008 Fredag Februari 2008 L÷rdag Februari 2008 S÷ndag Februari 2008 Mσndag Februari 2008 Tisdag Februari 2008 Onsdag Februari 2008 (7 rows) Gevik=# set lc_messages to 'de_DE'; SET Gevik=# select to_char((current_date + s.a),'TMDay TMMonth YYYY') as dates from generate_series(0,6) as s(a); dates ------------------------- Donnerstag Februar 2008 Freitag Februar 2008 Samstag Februar 2008 Sonntag Februar 2008 Montag Februar 2008 Dienstag Februar 2008 Mittwoch Februar 2008 (7 rows) Gevik=# set lc_messages to 'English_United_States'; SET Gevik=# select to_char((current_date + s.a),'TMDay TMMonth YYYY') as dates from generate_series(0,6) as s(a); dates ------------------------- Thursday February 2008 Friday February 2008 Saturday February 2008 Sunday February 2008 Monday February 2008 Tuesday February 2008 Wednesday February 2008 (7 rows) Gevik=# set lc_messages to 'tr-TR'; SET Gevik=# select to_char((current_date + s.a),'TMDay TMMonth YYYY') as dates from generate_series(0,6) as s(a); dates ---------------------- Persembe Subat 2008 Cuma Subat 2008 Cumartesi Subat 2008 Pazar Subat 2008 Pazartesi Subat 2008 Sali Subat 2008 ╟arsamba Subat 2008 (7 rows) Gevik=# set lc_messages to 'fr'; SET Gevik=# select to_char((current_date + s.a),'TMDay TMMonth YYYY') as dates from generate_series(0,6) as s(a); dates ----------------------- Jeudi FΘvrier 2008 Vendredi FΘvrier 2008 Samedi FΘvrier 2008 Dimanche FΘvrier 2008 Lundi FΘvrier 2008 Mardi FΘvrier 2008 Mercredi FΘvrier 2008 (7 rows) Gevik=#