diff options
| author | Bruce Momjian <bruce@momjian.us> | 2002-10-16 03:44:28 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2002-10-16 03:44:28 +0000 |
| commit | 6b0e166644cd33e96bbb907190592ec1e88d644b (patch) | |
| tree | 17dce705bf817b65f12a6b049c4db604b564521d /src/bin/scripts/createdb | |
| parent | 5d8c67462d93b33b13fe5e45b26002b8e625002c (diff) | |
| download | postgresql-6b0e166644cd33e96bbb907190592ec1e88d644b.tar.gz postgresql-6b0e166644cd33e96bbb907190592ec1e88d644b.zip | |
Improve appearance of SET command.
Diffstat (limited to 'src/bin/scripts/createdb')
| -rw-r--r-- | src/bin/scripts/createdb | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/bin/scripts/createdb b/src/bin/scripts/createdb index ad837191200..e951ed40a0d 100644 --- a/src/bin/scripts/createdb +++ b/src/bin/scripts/createdb @@ -12,7 +12,7 @@ # # # IDENTIFICATION -# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/createdb,v 1.26 2002/10/16 03:24:09 momjian Exp $ +# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/createdb,v 1.27 2002/10/16 03:44:28 momjian Exp $ # #------------------------------------------------------------------------- @@ -189,7 +189,7 @@ withstring= [ "$TEMPLATE" ] && withstring="$withstring TEMPLATE = \"$TEMPLATE\"" [ "$withstring" ] && withstring=" WITH$withstring" -${PATHNAME}psql $PSQLOPT -d template1 -c "SET autocommit = 'on';CREATE DATABASE \"$dbname\"$withstring" +${PATHNAME}psql $PSQLOPT -d template1 -c "SET autocommit TO 'on';CREATE DATABASE \"$dbname\"$withstring" if [ "$?" -ne 0 ]; then echo "$CMDNAME: database creation failed" 1>&2 exit 1 @@ -200,7 +200,7 @@ fi dbcomment=`echo "$dbcomment" | sed "s/'/\\\\\'/g"` -${PATHNAME}psql $PSQLOPT -d "$dbname" -c "SET autocommit = 'on';COMMENT ON DATABASE \"$dbname\" IS '$dbcomment'" +${PATHNAME}psql $PSQLOPT -d "$dbname" -c "SET autocommit TO 'on';COMMENT ON DATABASE \"$dbname\" IS '$dbcomment'" if [ "$?" -ne 0 ]; then echo "$CMDNAME: comment creation failed (database was created)" 1>&2 exit 1 |