PostgreSQL: encoding problems on Windows when using psql command line utility

by

Thanks a lot Craig Ringer, works, finally works! You are my new idool now!

The steps are:

  1. open the cmd
  2. SET PGCLIENTENCODING=utf-8
  3. chcp 65001
  4. psql -h your.ip.addr.ess -U postgres

More Related Contents:

  1. How do you use script variables in psql?
  2. Is there a shortcut for SELECT * FROM?
  3. Select rows which are not present in other table
  4. Optimize GROUP BY query to retrieve latest row per user
  5. How to implement a many-to-many relationship in PostgreSQL?
  6. How do I specify a password to ‘psql’ non-interactively?
  7. Check if value exists in Postgres array
  8. sql statement error: “column .. does not exist”
  9. What is the difference between single quotes and double quotes in PostgreSQL?
  10. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  11. Best way to count rows by arbitrary time intervals
  12. PostgreSQL sequence based on another column
  13. Sorting null values after all others, except special
  14. Finding similar strings with PostgreSQL quickly
  15. Reference alias in WHERE clause
  16. Fastest check if row exists in PostgreSQL
  17. Why do NULL values come first when ordering DESC in a PostgreSQL query?
  18. Slow simple update query on PostgreSQL database with 3 million rows
  19. Discard millisecond part from timestamp
  20. Return setof record (virtual table) from function
  21. SQL column reference “id” is ambiguous
  22. IN Clause with NULL or IS NULL
  23. How to convert PostgreSQL 9.4’s jsonb type to float
  24. postgres – where in (list) – column does not exist
  25. incomplete information from query on pg_views [duplicate]
  26. PostgreSQL: Give all permissions to a user on a PostgreSQL database
  27. Referencing current row in FILTER clause of window function
  28. Return rows from INSERT with ON CONFLICT without needing to update
  29. Insert data and set foreign keys with Postgres
  30. How to use a ring data structure in window functions

Leave a Comment