diff options
Diffstat (limited to 'db/pgsql')
-rw-r--r-- | db/pgsql/setup | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/db/pgsql/setup b/db/pgsql/setup index bb872ac..69beff1 100644 --- a/db/pgsql/setup +++ b/db/pgsql/setup @@ -16,6 +16,13 @@ host odb_test odb_test 192.168.0.0/24 trust create database odb_test; grant all privileges on database odb_test to odb_test; -* If need to add hstore support: +* If need to add hstore support (postgresql-contrib-X.Y package): + + For 8.x: psql odb_test -f /usr/share/postgresql/8.4/contrib/hstore.sql + + For 9.x: + + psql odb_test + CREATE EXTENSION hstore; |