By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,191 Members | 1,256 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,191 IT Pros & Developers. It's quick & easy.

i18n support in Postgresql

P: 2
How to enable i18n in Postgresql database?

I changed the executing environment to a Portuguese locale, and initdb to create a database cluster in the Portuguese locale. The command prompt showed 'invalid locale name pt_PT' but still created the cluster in the Portuguese locale.

The problem is how to check if the pgAdmin is now in new locale. The error messages here are still appearing in English, and to_char for month or day name also appears in english but not in Portuguese.

Any ideas if to-char was fixed to display month and day names in localized form?

Jan 21 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 700
Does postgres support portuguese locale?
Jan 21 '08 #2

P: 2
How do we check if Postgresql supports Portuguese?

The documentation says it has locale support. It may not support displaying error messages in Portuguese, but atleast to_char(current_timestamp,'DAY') should have displayed portuguese day name. This seemed to have been fixed in Postgresql 8.3 rc, but to _char still does not display Portuguese day and month names.
Jan 22 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.