<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_table.sgml,v 1.64 2003/04/14 15:24:46 tgl Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_table.sgml,v 1.65 2003/04/14 15:40:02 tgl Exp $

PostgreSQL documentation

-->

<title id="SQL-CREATETABLE-compatibility-title">Compatibility</title>

<para>

The <command>CREATE TABLE</command> conforms to SQL92 Intermediate

The <command>CREATE TABLE</command>commandconforms to SQL92

and to a subset of SQL99, with exceptions listed below and in the

descriptions above.

</para>

<productname>PostgreSQL</productname> does not have modules, and

requires each session to issue its own <literal>CREATE TEMPORARY

TABLE</literal> command for each temporary table to be used.

The notion of <literal>GLOBAL</literal> temporary tables found in SQL92

is not in <productname>PostgreSQL</productname> at all.

</para>

<note>

</note>

<para>

Theoptional<literal>ON COMMIT</literal> clause for temporary tables

The <literal>ON COMMIT</literal> clause for temporary tables

also resembles SQL92, but has some differences.

If the <literal>ON COMMIT</> clause is omitted, SQL92 specifies that the

default behavior is <literal>ON COMMIT DELETE ROWS</>. However, the