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.
+3
A:
SET lc_messages TO 'en_US.UTF-8';
More info on requirements and limitations here.
Milen A. Radev
2008-10-10 15:46:49
Unfortunately this does not seem to have any effect when the database server is installed on Windows.
Bno
2008-10-13 11:05:25
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
2008-10-13 21:16:53
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.
Milen A. Radev
2008-10-13 21:23:03
Works in Ubuntu.
Silence
2010-09-16 19:15:52