To resolve charset conflict error between utf8 and WIN1252, do the following before any further command are issued in PSQL:
Category: Postgresql
Postgresql Related Notes
If you’ve installed postgresql using the installer, it typically sets the service to start automatically when Windows is started. To
PHP with Postgresql
If PHP is installed as part of XAMPP, it will work with MySQL/MariaDB with no additional change. However, to work
Use Psql to test database connection after install
Note: command case sensitive. Issued from shell at <install directory>/bin psql -d mydb -U myuser To change database: \c databasename
Running PSQL after first PostgreSQL install on Windows 10
First, make sure Postgresql is running. A way to start the server is by issuing postgres -D ..\data in the
Switching Ofbiz 16.11.04 to Postgresql 9.6 on Windows 10
Follow instruction from Ofbiz technical set up guide. Download 64 bit Postgresql. This download will include a version of pgadmin.