C:\Program Files\PostgreSQL\9.0\bin> chcp
Текущая кодовая страница: 866

C:\Program Files\PostgreSQL\9.0\bin> psql -U postgres
psql (9.0.3)
WARNING: Console code page (866) differs from Windows code page (1251)
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users" for details.
Type "help" for help.

postgres=# select * from "Test";
name
----------
╨а╤П╨╝╤З╨╕╨║╨ж╨Щ
John
(2 rows)


postgres=# \q

C:\Program Files\PostgreSQL\9.0\bin> chcp 1251
Текущая кодовая страница: 1251

C:\Program Files\PostgreSQL\9.0\bin> psql -U postgres
psql (9.0.3)
Type "help" for help.

postgres=# select * from "Test";
name
----------
РямчикЦЙ
John
(2 rows)


postgres=#

что делать?

C:\Program Files\PostgreSQL\9.0\bin>psql -U postgres
psql (9.0.3)
WARNING: Console code page (866) differs from Windows code page (1251)
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users" for details.
Type "help" for help.

postgres=#
postgres=#
postgres=# select * from "Test";
name
----------
[b] ╨а╤П╨╝╤З╨╕╨║╨ж╨Щ
John [/b]


(4 rows)


postgres=# \encoding win-1251
postgres=# select * from "Test";
name
----------
╨ ьўшъ╓╔
John


(4 rows)


postgres=# SET client_encoding=win866;
SET
postgres=# select * from "Test";
name
----------
ДнямчикЦЙ
Rom


(4 rows)


postgres=#

ОКТОГЕН спасибо