Skip site navigation (1) Skip section navigation (2)

Re: garbage in psql -l

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Cc: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: garbage in psql -l
Date: 2009-11-24 18:46:19
Message-ID: 21232.1259088379@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> writes:
> On Tue, 24 Nov 2009, Tom Lane wrote:
>> What's your locale environment?  ("env | grep ^L" would help.)

> LC_COLLATE=ru_RU.KOI8-R
> LANG=C
> LC_CTYPE=ru_RU.KOI8-R

Hmm, I can duplicate the fact that psql -l uses utf8 characters
(because it connects to the postgres DB which has utf8 encoding)
but for me, ordinary selects within psql use the utf8 characters
too.  Do you perhaps have something in ~/.psqlrc to force a different
client encoding?

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Peter EisentrautDate: 2009-11-24 18:51:58
Subject: Re: garbage in psql -l
Previous:From: Tom LaneDate: 2009-11-24 18:34:22
Subject: Re: [HACKERS] Updating column on row update

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group