<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_table.sgml,v 1.37 2000/12/25 23:15:26 petere Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_table.sgml,v 1.38 2000/12/30 19:00:11 petere Exp $

Postgres documentation

-->

<date>2000-03-25</date>

</refsynopsisdivinfo>

<synopsis>

CREATE [ TEMPORARY | TEMP ] TABLE <replaceable class="PARAMETER">table</replaceable> (

CREATE [ TEMPORARY | TEMP ] TABLE <replaceable class="PARAMETER">table</replaceable>

[ UNDER <replaceable>inherited_table</replaceable> [, ...] ]

(

<replaceable class="PARAMETER">column</replaceable> <replaceable class="PARAMETER">type</replaceable>

[ NULL | NOT NULL ] [ UNIQUE ] [ DEFAULT <replaceable class="PARAMETER">value</replaceable> ]

[<replaceable>column_constraint_clause</replaceable> | PRIMARY KEY } [ ... ] ]

[, ... ]

[, PRIMARY KEY ( <replaceable class="PARAMETER">column</replaceable> [, ...] ) ]

[, CHECK ( <replaceable class="PARAMETER">condition</replaceable> ) ]

[, <replaceable>table_constraint_clause</replaceable> ]

) [ UNDER <replaceable>inherited_table</replaceable> [, ...] ]

)

</synopsis>

<refsect2 id="R2-SQL-CREATETABLE-1">

<term><replaceable class="PARAMETER">table</replaceable></term>

<listitem>

<para>

The name ofa new class or table to be created.

The name ofthe new table to be created.

</para>

</listitem>

</varlistentry>

</title>

<para>

<command>CREATE TABLE</command> will enter a newclass ortable

<command>CREATE TABLE</command> will enter a new table

into the current data base. The table will be "owned" by the user issuing the

command.

</para>

<para>

The optional UNDER

clause specifies a collection ofclass names from which thisclass

clause specifies a collection oftable names from which thistable

automatically inherits all fields. If any inherited field name

appears more than once, Postgres reports an error. Postgres automatically

allows the createdclass to inherit functions onclasses above it in

allows the createdtable to inherit functions ontables above it in

the inheritance hierarchy. Inheritance of functions is done according

to the conventions of the Common Lisp Object System (CLOS).

</para>

<para>

Each new tableor class<replaceable class="PARAMETER">table</replaceable>

is automatically created as a type. Therefore, one or moreinstances

from theclass are automatically a type and can be used in

Each new table <replaceable class="PARAMETER">table</replaceable>

is automatically created as a type. Therefore, one or morerows

from thetable are automatically a type and can be used in

<xref linkend="sql-altertable" endterm="sql-altertable-title">

or other <command>CREATE TABLE</command> statements.

</para>

</programlisting>

</para>

<refsect2 id="R2-SQL-CREATETABLE-3">

<title>

Notes

</title>

<para>

CREATE TABLE/UNDER is defined by SQL3. Multiple inheritance is a

<productname>Postgres</productname> language extension.

</para>

</refsect2>

</refsect1>

<refsect1 id="R1-SQL-CREATETABLE-3">