aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorRobin Houston <robin.houston@gmail.com>2012-01-06 13:24:56 +0000
committerRobin Houston <robin.houston@gmail.com>2012-01-06 13:24:56 +0000
commit6c22c60b16f5653920ff894ca6732f539e4139a9 (patch)
treec83612cea58876af5c0878dcdd3175c6d44782d3
parentb97c388419ff4cd42efb6ad665c255b954858822 (diff)
Fix CREATE DATABASE command
Creating a database in SQL_ASCII encoding requires using template0.
-rw-r--r--doc/INSTALL.md4
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;