Change the UI language of psql connection
I have a PostgreSQL 8.4 database, installed with Japanese as the main
language. I am connecting from an English Windows 7 client using
psql.exe. Is there any way to change the UI of the messages shown to
me (e.g. the help, column headers from the \l command, etc) to
English?
I know that I can set the character encoding using \encoding, but this
is not the same. I want to change the UI language from ja_JP to en_US
(or similar).
I can't see anything in the psql documentation. Any ideas?
Regards,
Brodie
Brodie Thiesfield <brofield@gmail.com> writes:
I have a PostgreSQL 8.4 database, installed with Japanese as the main
language. I am connecting from an English Windows 7 client using
psql.exe. Is there any way to change the UI of the messages shown to
me (e.g. the help, column headers from the \l command, etc) to
English?
set lc_messages to an appropriate locale.
regards, tom lane
On Mon, Sep 13, 2010 at 12:33 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Brodie Thiesfield <brofield@gmail.com> writes:
I have a PostgreSQL 8.4 database, installed with Japanese as the main
language. I am connecting from an English Windows 7 client using
psql.exe. Is there any way to change the UI of the messages shown to
me (e.g. the help, column headers from the \l command, etc) to
English?set lc_messages to an appropriate locale.
Ah yes. I forgot about that. That fixed my problem, thanks.
Brodie