Recently, accidentally deleted environment variables when added a new variable. Previously used the “CHCP 1251” command and everything worked well, Russian characters were perfectly displayed. After removing environment variables, everything is displayed as on the screen. Variables of the environment added back, those that use those that should be by default. But apparently need some other way.
Tell me, please, if anyone came across a similar problem that you need to add or how to cope with a similar problem.
Answer 1, Authority 100%
Try Run:
psql -d YourBase -u YourLogin
and set the encoding:
set client_encoding = 'win1251';
Answer 2, Authority 100%
The question was solved by adding some environment variables that were absent from me. I looked at my colleagues on my computer and added.
Next, executed instructions from here https://iu5bmstu.ru/index.php/postgreSQL_-_% D0% 9A% D0% B8% D1% 80% D0% B8% D0% BB% D0% BB% D0% B8% D1% 86% D0% B0_% D0% B2_PSQL_% D0% BF% D0% BE% D0% B4_Windows
As a result, everything worked as before.
Good luck to all. Do not remove your environment variables like me)))))
Answer 3
from psql
-client coding “win1251” can be installed by the command:
\! CHCP 1251.