开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 数据库系统 > 查看源码
create_database.sgml
资源名称：postgresql-6.5.2.tar.gz　[点击查看]
上传用户：blenddy
上传日期：2007-01-07
资源大小：6495k
文件大小：6k
源码类别：

数据库系统

开发平台：

Unix_Linux

create_database.sgml：源码内容
  1. <refentry id="SQL-CREATEDATABASE">
  2.  <refmeta>
  3.   <refentrytitle>
  4.    CREATE DATABASE
  5.   </refentrytitle>
  6.   <refmiscinfo>SQL - Language Statements</refmiscinfo>
  7.  </refmeta>
  8.  <refnamediv>
  9.   <refname>
  10.    CREATE DATABASE
  11.   </refname>
  12.   <refpurpose>
  13.    Creates a new database
  14.   </refpurpose>
  15.  </refnamediv>
  16.  <refsynopsisdiv>
  17.   <refsynopsisdivinfo>
  18.    <date>1998-04-15</date>
  19.   </refsynopsisdivinfo>
  20.   <synopsis>
  21. CREATE DATABASE <replaceable class="PARAMETER">name</replaceable> [ WITH LOCATION = '<replaceable class="parameter">dbpath</replaceable>' ]
  22.   </synopsis>
  24.   <refsect2 id="R2-SQL-CREATEDATABASE-1">
  25.    <refsect2info>
  26.     <date>1998-04-15</date>
  27.    </refsect2info>
  28.    <title>
  29.     Inputs
  30.    </title>
  31.    <para>
  33.     <variablelist>
  34.      <varlistentry>
  35.       <term><replaceable class="parameter">name</replaceable></term>
  36.       <listitem>
  37.        <para>
  38. The name of a database to create.
  39.        </para>
  40.       </listitem>
  41.      </varlistentry>
  42.      <varlistentry>
  43.       <term><replaceable class="parameter">dbpath</replaceable></term>
  44.       <listitem>
  45.        <para>
  46. An alternate location can be specified as either an
  47. environment variable known to the backend server
  48. (e.g. '<envar>PGDATA2</envar>') or as an absolute path name
  49. (e.g. '<filename>/usr/local/pgsql/data</filename>').
  50. In either case, the location must be pre-configured
  51. by <command>initlocation</command>.
  52.        </para>
  53.       </listitem>
  54.      </varlistentry>
  55.     </variablelist>
  56.    </para>
  57.   </refsect2>
  59.   <refsect2 id="R2-SQL-CREATEDATABASE-2">
  60.    <refsect2info>
  61.     <date>1998-04-15</date>
  62.    </refsect2info>
  63.    <title>
  64.     Outputs
  65.    </title>
  66.    <para>
  68.     <variablelist>
  69.      <varlistentry>
  70.       <term><computeroutput>
  71. CREATEDB
  72.        </computeroutput></term>
  73.       <listitem>
  74.        <para>
  75. Message returned if the command completes successfully.
  76.        </para>
  77.       </listitem>
  78.      </varlistentry>
  79.      <varlistentry>
  80.       <term><computeroutput>
  81. WARN:  createdb: database "<replaceable class="parameter">name</replaceable>" already exists.
  82.        </computeroutput></term>
  83.       <listitem>
  84.        <para>
  85. This occurs if <replaceable class="parameter">database</replaceable> specified already exists.
  86.        </para>
  87.       </listitem>
  88.      </varlistentry>
  89.      <varlistentry>
  90.       <term><computeroutput>
  91. ERROR:  Unable to create database directory <replaceable class="parameter">directory</replaceable>
  92.        </computeroutput></term>
  93.       <listitem>
  94.        <para>
  95. There was a problem with creating the required directory; this operation will
  96. need permissions for the <literal>postgres</literal> user on the specified location.
  97.        </para>
  98.       </listitem>
  99.      </varlistentry>
  100.     </variablelist>
  101.    </para>
  102.   </refsect2>
  103.  </refsynopsisdiv>
  105.  <refsect1 id="R1-SQL-CREATEDATABASE-1">
  106.   <refsect1info>
  107.    <date>1998-04-15</date>
  108.   </refsect1info>
  109.   <title>
  110.    Description
  111.   </title>
  112.   <para>
  113.    <command>CREATE DATABASE</command> creates a new Postgres database.
  114.    The creator becomes the administrator of the new database.
  115.   </para>
  117.   <refsect2 id="R2-SQL-CREATEDATABASE-3">
  118.    <refsect2info>
  119.     <date>1998-04-15</date>
  120.    </refsect2info>
  121.    <title>
  122.     Notes
  123.    </title>
  124.    <para>
  125.     <command>CREATE DATABASE</command> is a <productname>Postgres</productname>
  126.     language extension.
  127.    </para>
  128.    <para>
  129.     Use <command>DROP DATABASE</command> to remove a database.
  130.    </para>
  131.   </refsect2>
  132.  </refsect1>
  134.  <refsect1 id="R1-SQL-CREATEDATABASE-2">
  135.   <title>
  136.    Usage
  137.   </title>
  138.   <para>
  139.    To create a new database:
  141.    <programlisting>
  142. <prompt>olly=></prompt> <userinput>create database lusiadas;</userinput>
  143.    </programlisting>
  144.   </para>
  146.   <para>
  147.    To create a new database in an alternate area <filename>~/private_db</filename>:
  149.    <programlisting>
  150. <prompt>$</prompt> <userinput>mkdir private_db</userinput>
  151. <prompt>$</prompt> <userinput>initlocation ~/private_db</userinput>
  152. <computeroutput>Creating Postgres database system directory /home/olly/private_db/base</computeroutput>
  153.    
  154.    <prompt>$</prompt> <userinput>psql olly</userinput>
  155.    <computeroutput>Welcome to the POSTGRESQL interactive sql monitor:
  156.     Please read the file COPYRIGHT for copyright terms of POSTGRESQL
  157.     
  158.     type ? for help on slash commands
  159.     type q to quit
  160.     type g or terminate with semicolon to execute query
  161.     You are currently connected to the database: template1
  162.     
  163.     <prompt>olly=></prompt></computeroutput> <userinput>create database elsewhere with location = '/home/olly/private_db';</userinput>
  164.    <computeroutput>CREATEDB</computeroutput>
  165.    </programlisting>
  166.   </para>
  167.  </refsect1>
  169.  <refsect1 id="R1-SQL-CREATEDATABASE-3">
  170.   <title>
  171.    Bugs
  172.   </title>
  173.   <para>
  174.    There are security and data integrity issues
  175.    involved with using alternate database locations
  176.    specified with absolute path names, and by default
  177.    only an environment variable known to the backend may be
  178.    specified for an alternate location.
  179.    See the Administrator's Guide for more information.
  180.   </para>
  181.  </refsect1>
  183. <!--
  184. comment from Olly; response from Thomas...
  185.   <comment>
  186.    initlocation does not create a PG_VERSION file in the specified location.
  187.    How will Postgres handle the situation if it is upgraded to an 
  188.    incompatible database version?
  189.   </comment>
  190. Hmm. This isn't an issue since the upgrade would do a dump/reload from the main database area also.
  191. Not sure if the dump/reload would guarantee that the alternate data area gets refreshed though...
  192. -->
  193.  
  194.  <refsect1 id="R1-SQL-CREATEDATABASE-4">
  195.   <title>
  196.    Compatibility
  197.   </title>
  199.   <refsect2 id="R2-SQL-CREATEDATABASE-4">
  200.    <refsect2info>
  201.     <date>1998-04-15</date>
  202.    </refsect2info>
  203.    <title>
  204.     SQL92
  205.    </title>
  206.    <para>
  207.     There is no <command>CREATE DATABASE</command> statement in SQL92.
  208.    </para>
  209.    <para>
  210.     The equivalent command in standard SQL is <command>CREATE SCHEMA</command>.
  211.    </para>
  212.   </refsect2>
  213.  </refsect1>
  214. </refentry>
  216. <!-- Keep this comment at the end of the file
  217. Local variables:
  218. mode: sgml
  219. sgml-omittag:nil
  220. sgml-shorttag:t
  221. sgml-minimize-attributes:nil
  222. sgml-always-quote-attributes:t
  223. sgml-indent-step:1
  224. sgml-indent-data:t
  225. sgml-parent-document:nil
  226. sgml-default-dtd-file:"../reference.ced"
  227. sgml-exposed-tags:nil
  228. sgml-local-catalogs:"/usr/lib/sgml/catalog"
  229. sgml-local-ecat-files:nil
  230. End:
  231. -->