PostgreSQLã§templateã¨ç•°ãªã‚‹encoding,collate,ctypeã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’作æˆã™ã‚‹å ´åˆã€ ã“ã‚“ãªé¢¨ã«createdbã§æŒ‡å®šã‚’è¡Œã„ã¾ã™ã€‚ $ createdb -E UTF8 -T template0 --lc-collate=ja_JP.UTF-8 --lc-ctype=ja_JP.UTF-8 testdb # su - postgres $ psql postgres=# \l List of databases Name    | Owner | Encoding | Collate |    Ctype    | Access privileges -----------+----------+-----------+-------------+-------------+----------------------- postgres | postg

{{#tags}}- {{label}}
{{/tags}}