Escape tablespace name when creating postgresql tablespace

[hcoop/scripts.git] / create-user-database

diff --git a/create-user-database b/create-user-database
index cf855c4..bc2ca60 100755 (executable)
--- a/create-user-database
+++ b/create-user-database
@@ -16,7 +16,7 @@ MYSQLDIR=$DBPATH/mysql
 if ! test -d $PGDIR; then
   mkdir -p $PGDIR
   chown postgres:postgres $PGDIR
-  sudo -u postgres psql -c "CREATE TABLESPACE user_$USER OWNER postgres LOCATION '$PGDIR'" template1
+  sudo -u postgres psql -c "CREATE TABLESPACE \"user_$USER\" OWNER postgres LOCATION '$PGDIR'" template1
 fi
 
 # Create mysql user and databases placeholder within volume