When trying to connect to my first PostgreSQL database, got the below warning :
C:>psql -h 192.168.78.51 -U postgres -d postgres Password for user postgres: psql (9.6.3) WARNING: Console code page (850) differs from Windows code page (1252) 8-bit characters might not work correctly. See psql reference page "Notes for Windows users" for details. Type "help" for help.
Below are extracted from psql reference page “Notice for Windows users”:
Notes for Windows Users psql is built as a "console application". Since the Windows console windows use a different encoding than the rest of the system, you must take special care when using 8-bit characters within psql. If psql detects a problematic console code page, it will warn you at startup. To change the console code page, two things are necessary: Set the code page by entering cmd.exe /c chcp 1252. (1252 is a code page that is appropriate for German; replace it with your value.) If you are using Cygwin, you can put this command in /etc/profile. Set the console font to Lucida Console, because the raster font does not work with the ANSI code page.
Set the code page to 1252 , and connect to server without warning:
C:>chcp 1252 Active code page: 1252 C:>psql -h 192.168.78.51 -U postgres -d postgres Password for user postgres: psql (9.6.3) Type "help" for help. postgres=#