Monday, February 21, 2011

Change language of system and error messages in PostgreSQL

Is it possible to change the language of system messages from PostgreSQL?

In MSSQL for instance this is possible with the SQL statement SET LANGUAGE.

From stackoverflow
  • SET lc_messages TO 'en_US.UTF-8';
    

    More info on requirements and limitations here.

    Bno : Unfortunately this does not seem to have any effect when the database server is installed on Windows.
    Milen A. Radev : According to this bug report - http://archives.postgresql.org/pgsql-bugs/2008-05/msg00134.php, you're right. Have you tried to change the 'lc_messages' setting directly in the postgresql.conf and to restart?
    Milen A. Radev : Now, after reading the mentioned thread in the archives, the only way to change the language of the system messages seems to be to change the OS locale.
    Silence : Works in Ubuntu.

0 comments:

Post a Comment