[Howto] create PostgreSQL database with UTF-8 encoding

posted in: computer | 0

postgreSQL v9.6

CREATE DATABASE testdb ENCODING 'utf8' LC_COLLATE 'de_DE.UTF-8' LC_CTYPE 'de_DE.UTF-8' TEMPLATE template0;