File: sql-createdatabase.html

package info (click to toggle)
mpsql 2.1-2
links: PTS
area: non-free
in suites: potato
size: 3,528 kB
ctags: 4,886
sloc: ansic: 35,184; makefile: 3,761; sh: 44
file content (428 lines) | stat: -rw-r--r-- 5,849 bytes
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML
><HEAD
><TITLE
>   CREATE DATABASE
  </TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet version 1.19"><LINK
REL="HOME"
TITLE="PostgreSQL User's Guide"
HREF="user.html"><LINK
REL="UP"
TITLE="SQL Commands"
HREF="sql-commands.html"><LINK
REL="PREVIOUS"
TITLE="   CREATE AGGREGATE
  "
HREF="sql-createaggregate.html"><LINK
REL="NEXT"
TITLE="   CREATE FUNCTION
  "
HREF="sql-createfunction.html"></HEAD
><BODY
BGCOLOR="#FFFFFF"
TEXT="#000000"
><DIV
CLASS="NAVHEADER"
><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="3"
ALIGN="center"
>PostgreSQL User's Guide</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="sql-createaggregate.html"
>Prev</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="sql-createfunction.html"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
>CREATE DATABASE</H1
><DIV
CLASS="REFNAMEDIV"
><H2
>Name</H2
>   CREATE DATABASE
   &#8212;    Creates a new database
  </DIV
><DIV
CLASS="REFSYNOPSISDIV"
><PRE
CLASS="SYNOPSIS"
>CREATE DATABASE <TT
CLASS="REPLACEABLE"
><I
>name</I
></TT
> [ WITH LOCATION = '<TT
CLASS="REPLACEABLE"
><I
>dbpath</I
></TT
>' ]
  </PRE
><DIV
CLASS="REFSECT2"
><H3
>    Inputs
   </H3
><P
>       <P
></P
></P><DL
><DT
><TT
CLASS="REPLACEABLE"
><I
>name</I
></TT
></DT
><DD
><P
>	   The name of a database to create.
	  </P
></DD
><DT
><TT
CLASS="REPLACEABLE"
><I
>dbpath</I
></TT
></DT
><DD
><P
>	   An alternate location can be specified as either an
	   environment variable known to the backend server
	   (e.g. '<TT
CLASS="ENVAR"
>PGDATA2</TT
>') or as an absolute path name
	   (e.g. '<TT
CLASS="FILENAME"
>/usr/local/pgsql/data</TT
>').
	   In either case, the location must be pre-configured
	   by <B
CLASS="COMMAND"
>initlocation</B
>.
	  </P
></DD
></DL
><P>
  </P
></DIV
><DIV
CLASS="REFSECT2"
><H3
>    Outputs
   </H3
><P
>&#13;       <P
></P
></P><DL
><DT
><SPAN
CLASS="RETURNVALUE"
>CREATEDB</SPAN
></DT
><DD
><P
>          Message returned if the command completes successfully.
	  </P
></DD
><DT
><SPAN
CLASS="RETURNVALUE"
>WARN:  createdb: database "<TT
CLASS="REPLACEABLE"
><I
>name</I
></TT
>" already exists.</SPAN
></DT
><DD
><P
>	   This occurs if <TT
CLASS="REPLACEABLE"
><I
>database</I
></TT
> specified already exists.
	  </P
></DD
><DT
><SPAN
CLASS="RETURNVALUE"
>ERROR:  Unable to create database directory <TT
CLASS="REPLACEABLE"
><I
>directory</I
></TT
></SPAN
></DT
><DD
><P
>There was a problem with creating the required directory; this operation will
need permissions for the <TT
CLASS="LITERAL"
>postgres</TT
> user on the specified location.

   </P
></DD
></DL
><P>
  </P
></DIV
></DIV
><DIV
CLASS="REFSECT1"
><H2
>   Description
  </H2
><P
>   <B
CLASS="COMMAND"
>CREATE DATABASE</B
> creates a new Postgres database.
   The creator becomes the administrator of the new database.
  </P
><DIV
CLASS="REFSECT2"
><H3
>    Notes
   </H3
><P
>    <B
CLASS="COMMAND"
>CREATE DATABASE</B
> is a <SPAN
CLASS="PRODUCTNAME"
>Postgres</SPAN
>
 language extension.
   </P
><P
>    Use <B
CLASS="COMMAND"
>DROP DATABASE</B
> to remove a database.
   </P
></DIV
></DIV
><DIV
CLASS="REFSECT1"
><H2
>   Usage
  </H2
><P
>   To create a new database:
  </P
><PRE
CLASS="PROGRAMLISTING"
><TT
CLASS="PROMPT"
>olly=&#62;</TT
> <TT
CLASS="USERINPUT"
><B
>create database lusiadas;</B
></TT
>
  </PRE
><P
>   To create a new database in an alternate area <TT
CLASS="FILENAME"
>~/private_db</TT
>:
  </P
><PRE
CLASS="PROGRAMLISTING"
><TT
CLASS="PROMPT"
>$</TT
> <TT
CLASS="USERINPUT"
><B
>mkdir private_db</B
></TT
>
<TT
CLASS="PROMPT"
>$</TT
> <TT
CLASS="USERINPUT"
><B
>initlocation ~/private_db</B
></TT
>
<TT
CLASS="COMPUTEROUTPUT"
>Creating Postgres database system directory /home/olly/private_db/base</TT
>

<TT
CLASS="PROMPT"
>$</TT
> <TT
CLASS="USERINPUT"
><B
>psql olly</B
></TT
>
<TT
CLASS="COMPUTEROUTPUT"
>Welcome to the POSTGRESQL interactive sql monitor:
  Please read the file COPYRIGHT for copyright terms of POSTGRESQL

   type \? for help on slash commands
   type \q to quit
   type \g or terminate with semicolon to execute query
 You are currently connected to the database: template1

<TT
CLASS="PROMPT"
>olly=&#62;</TT
></TT
> <TT
CLASS="USERINPUT"
><B
>create database elsewhere with location = '/home/olly/private_db';</B
></TT
>
    <TT
CLASS="COMPUTEROUTPUT"
>CREATEDB</TT
>
  </PRE
></DIV
><DIV
CLASS="REFSECT1"
><H2
>   Bugs
  </H2
><P
>   There are security and data integrity issues
 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.
  </P
></DIV
><DIV
CLASS="REFSECT1"
><H2
>   Compatibility
  </H2
><P
>  
  </P
><DIV
CLASS="REFSECT2"
><H3
>    SQL92
   </H3
><P
>    There is no <B
CLASS="COMMAND"
>CREATE DATABASE</B
> statement in SQL92.
   </P
><P
>    The equivalent command in standard SQL is <B
CLASS="COMMAND"
>CREATE SCHEMA</B
>.
   </P
></DIV
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="sql-createaggregate.html"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="user.html"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="sql-createfunction.html"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>CREATE AGGREGATE</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="sql-commands.html"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>CREATE FUNCTION</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>