From c3b00e7e291cd9884bbdf768cfccb5dab8f142e8 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sun, 18 Feb 2001 17:53:55 +0000 Subject: Add --template option to createdb script to allow access to WITH TEMPLATE option of CREATE DATABASE. In pg_regress, create regression database from template0 to ensure that any installation-local cruft in template1 will not mess up the tests. --- doc/src/sgml/ref/createdb.sgml | 31 +++++++++++++++++++++++-------- 1 file changed, 23 insertions(+), 8 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/createdb.sgml b/doc/src/sgml/ref/createdb.sgml index d74941d8c81..4466c30548f 100644 --- a/doc/src/sgml/ref/createdb.sgml +++ b/doc/src/sgml/ref/createdb.sgml @@ -1,5 +1,5 @@ @@ -41,7 +41,7 @@ Postgres documentation Specifies the hostname of the machine on which the postmaster is running. If host begins with a slash, it is used - as the directory for the unix domain socket. + as the directory for the Unix-domain socket. @@ -98,17 +98,26 @@ Postgres documentation -D, --location datadir - Specifies the alternative database location. See also . + + -T, --template template + + + Specifies the template database from which to build this database. + + + + -E, --encoding encoding - Specifies the character encoding scheme to be used with this database. + Specifies the character encoding scheme to be used in this database. @@ -140,6 +149,12 @@ Postgres documentation The options -h, -p, -U, -W, and -e are passed on literally to . + + The options -D, -T, and + -E are converted into options for the underlying + SQL command , which see for more information + about them. @@ -168,7 +183,7 @@ Postgres documentation The comment/description for the database could not be created. - the database itself will have been created already. You can use the + The database itself will have been created already. You can use the SQL command COMMENT ON DATABASE to create the comment later on. @@ -199,10 +214,10 @@ Postgres documentation the Postgres interactive terminal . Thus, there is nothing special about creating databases via this or other methods. This means - that the psql must be found by the script and that - a database server is running at the targeted host. Also, any default + that the psql program must be found by the script and that + a database server must be running at the targeted port. Also, any default settings and environment variables available to psql - and the libpq front-end library do apply. + and the libpq front-end library will apply. -- cgit v1.2.3