Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision Both sides next revision
tutorial:adm:czechidm_installation_win [2020/04/21 11:43]
fiserp [Create DB user and database in PostgreSQL] 		tutorial:adm:czechidm_installation_win [2020/04/21 11:43]
fiserp [Create DB user and database in PostgreSQL]
Line 13: Line 13:
 CREATE USER czechidm PASSWORD '*****'; CREATE USER czechidm PASSWORD '*****';
  
-# Choose appropriate collation and create database. +-- Choose appropriate collation and create database. 
-# with english collation (we expect the default windows installation with cp1250/cp1252 and "English_United States" collation).+-- with english collation (we expect the default windows installation with cp1250/cp1252 and "English_United States" collation).
 CREATE DATABASE "czechidm" WITH OWNER 'czechidm' ENCODING 'UTF8' template 'template0'; CREATE DATABASE "czechidm" WITH OWNER 'czechidm' ENCODING 'UTF8' template 'template0';
-# with czech collation+-- with czech collation
 CREATE DATABASE "czechidm" WITH OWNER 'czechidm' ENCODING 'UTF8' LC_COLLATE = 'czech_czech' LC_CTYPE = 'czech_czech' template 'template0'; CREATE DATABASE "czechidm" WITH OWNER 'czechidm' ENCODING 'UTF8' LC_COLLATE = 'czech_czech' LC_CTYPE = 'czech_czech' template 'template0';
 </code> </code>
  • by fiserp