in bash
postgres@x1:~$ createdb database_name -l en_US.utf8 -E UTF8 -T template0
in psql
postgres=# CREATE DATABASE database_name ENCODING 'UTF8' LC_COLLATE='en_US.UTF-8' LC_CTYPE='en_US.UTF-8' TEMPLATE=template0;
postgres@x1:~$ createdb database_name -l en_US.utf8 -E UTF8 -T template0
postgres=# CREATE DATABASE database_name ENCODING 'UTF8' LC_COLLATE='en_US.UTF-8' LC_CTYPE='en_US.UTF-8' TEMPLATE=template0;
Share on Facebook, Twitter, Google+, Linkedin
comments powered by Disqus--