From a4ac2f458e8cb76177254f4bd7bbd885991379af Mon Sep 17 00:00:00 2001 From: "Thomas G. Lockhart" Date: Tue, 6 Jul 1999 17:16:42 +0000 Subject: Fix markup for docbook2man man page generation. No big deal; fixed lots of other markup at the same time. Bigest change: make sure there is no whitespace in front of contents. This will probably help the other output types too. --- doc/src/sgml/ref/create_database.sgml | 308 +++++++++++++++++----------------- 1 file changed, 153 insertions(+), 155 deletions(-) (limited to 'doc/src/sgml/ref/create_database.sgml') diff --git a/doc/src/sgml/ref/create_database.sgml b/doc/src/sgml/ref/create_database.sgml index 537db5f2ffa..cb0f18a589e 100644 --- a/doc/src/sgml/ref/create_database.sgml +++ b/doc/src/sgml/ref/create_database.sgml @@ -1,157 +1,155 @@ - - - + + + CREATE DATABASE - - SQL - Language Statements - - - + + SQL - Language Statements + + + CREATE DATABASE - - + + Creates a new database - + - - - 1998-04-15 - - -CREATE DATABASE name [ WITH LOCATION = 'dbpath' ] - - - - - 1998-04-15 - - + <refsynopsisdiv> + <refsynopsisdivinfo> + <date>1998-04-15</date> + </refsynopsisdivinfo> + <synopsis> +CREATE DATABASE <replaceable class="PARAMETER">name</replaceable> [ WITH LOCATION = '<replaceable class="parameter">dbpath</replaceable>' ] + </synopsis> + + <refsect2 id="R2-SQL-CREATEDATABASE-1"> + <refsect2info> + <date>1998-04-15</date> + </refsect2info> + <title> Inputs - - - - - - name - - - - The name of a database to create. - - - - - - dbpath - - - - An alternate location can be specified as either an - environment variable known to the backend server - (e.g. 'PGDATA2') or as an absolute path name - (e.g. '/usr/local/pgsql/data'). - In either case, the location must be pre-configured - by initlocation. - - - - + + + + + + name + + + The name of a database to create. + + + + + dbpath + + + An alternate location can be specified as either an + environment variable known to the backend server + (e.g. 'PGDATA2') or as an absolute path name + (e.g. '/usr/local/pgsql/data'). + In either case, the location must be pre-configured + by initlocation. + + + + - - - - - 1998-04-15 - - + </refsect2> + + <refsect2 id="R2-SQL-CREATEDATABASE-2"> + <refsect2info> + <date>1998-04-15</date> + </refsect2info> + <title> Outputs - - + + - - - - CREATEDB - - - - Message returned if the command completes successfully. - - - - - - WARN: createdb: database "name" already exists. - - - - This occurs if database specified already exists. - - - - - - ERROR: Unable to create database directory directory - - - - + + + +CREATEDB + + + + Message returned if the command completes successfully. + + + + + +WARN: createdb: database "name" already exists. + + + + This occurs if database specified already exists. + + + + + +ERROR: Unable to create database directory directory + + + There was a problem with creating the required directory; this operation will need permissions for the postgres user on the specified location. - + - - - - - - 1998-04-15 - - + </refsect2> + </refsynopsisdiv> + + <refsect1 id="R1-SQL-CREATEDATABASE-1"> + <refsect1info> + <date>1998-04-15</date> + </refsect1info> + <title> Description - - + + CREATE DATABASE creates a new Postgres database. The creator becomes the administrator of the new database. - - - - - 1998-04-15 - - + </para> + + <refsect2 id="R2-SQL-CREATEDATABASE-3"> + <refsect2info> + <date>1998-04-15</date> + </refsect2info> + <title> Notes - - + + CREATE DATABASE is a Postgres - language extension. - + language extension. + Use DROP DATABASE to remove a database. - + - - - + + <refsect1 id="R1-SQL-CREATEDATABASE-2"> + <title> Usage - - + + To create a new database: - - - olly=> create database lusiadas; - - + + +olly=> create database lusiadas; + + + + To create a new database in an alternate area ~/private_db: - - - $ mkdir private_db - $ initlocation ~/private_db - Creating Postgres database system directory /home/olly/private_db/base + + +$ mkdir private_db +$ initlocation ~/private_db +Creating Postgres database system directory /home/olly/private_db/base $ psql olly Welcome to the POSTGRESQL interactive sql monitor: @@ -164,21 +162,22 @@ CREATE DATABASE name [ WITH LOCATIO olly=> create database elsewhere with location = '/home/olly/private_db'; CREATEDB - - - - - + </programlisting> + </para> + </refsect1> + + <refsect1 id="R1-SQL-CREATEDATABASE-3"> + <title> Bugs - - + + There are security and data integrity issues - involved with using alternate database locations + involved with using alternate database locations specified with absolute path names, and by default -only an environment variable known to the backend may be -specified for an alternate location. - See the Administrator's Guide for more information. - + only an environment variable known to the backend may be + specified for an alternate location. + See the Administrator's Guide for more information. + - - + <refsect1 id="R1-SQL-CREATEDATABASE-4"> + <title> Compatibility - - - - - 1998-04-15 - - + + + + + 1998-04-15 + + SQL92 - - + + There is no CREATE DATABASE statement in SQL92. - + The equivalent command in standard SQL is CREATE SCHEMA. - - +