The following bug has been logged online:
Bug reference: 1060
Logged by: Hitoshi Gosen
Email address: mic-gosen@ns.inter-mic.co.jp
PostgreSQL version: 7.4
Operating system: linux 2.4.9
Description: psql encoding bug : sjis
Details:
version 7.4.1
installation steps:
./configure
gmake
su
gmake install
adduser postgres
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
/usr/local/pgsql/bin/postmaster - D usr/local/pgsql/data >logfile 2>&1 &
/usr/local/pgsql/bin/createdb test1
----------------------------------------
client:
/usr/local/pgsql/bin/psql test1
\encoding sjis
create table ãã¹ãæ å ±(ãã¹ã character(4));
\d
-----------------------------------------
the last command \d shows me a different name for the table.
I cannot access the table.