diff options
author | Robin Houston <robin.houston@gmail.com> | 2012-01-06 13:24:56 +0000 |
---|---|---|
committer | Robin Houston <robin.houston@gmail.com> | 2012-01-06 13:24:56 +0000 |
commit | 6c22c60b16f5653920ff894ca6732f539e4139a9 (patch) | |
tree | c83612cea58876af5c0878dcdd3175c6d44782d3 | |
parent | b97c388419ff4cd42efb6ad665c255b954858822 (diff) |
Fix CREATE DATABASE command
Creating a database in SQL_ASCII encoding requires using template0.
-rw-r--r-- | doc/INSTALL.md | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/doc/INSTALL.md b/doc/INSTALL.md index 963d0b6f0..b95534e4f 100644 --- a/doc/INSTALL.md +++ b/doc/INSTALL.md @@ -83,8 +83,8 @@ constraints whilst running the tests they also need to be a superuser. The following command will set up a user 'foi' with password 'foi': - echo "CREATE DATABASE foi_development encoding = 'SQL_ASCII'; - CREATE DATABASE foi_test encoding = 'SQL_ASCII'; + echo "CREATE DATABASE foi_development encoding 'SQL_ASCII' template template0; + CREATE DATABASE foi_test encoding 'SQL_ASCII' template template0; CREATE USER foi WITH CREATEUSER; ALTER USER foi WITH PASSWORD 'foi'; ALTER USER foi WITH CREATEDB; |