CREATE TABLE synopsis

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: CREATE TABLE synopsis
Date: 2005-08-12 16:12:20
Message-ID: 20050812161220.GB16468@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The CREATE TABLE synopsis shows this:

CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name (
{ column_name data_type [ DEFAULT default_expr ] [ column_constraint [ ... ] ]
| table_constraint
| LIKE parent_table [ { INCLUDING | EXCLUDING } DEFAULTS ] } [, ... ]
)

However, we now allow zero-column tables, so it should actually be

CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name (
[ column_name data_type [ DEFAULT default_expr ] [ column_constraint [ ... ] ]
| table_constraint
| LIKE parent_table [ { INCLUDING | EXCLUDING } DEFAULTS ] ] [, ... ]
)

Right?

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Wong 2005-08-12 17:49:43 Re: [HACKERS] Autovacuum loose ends
Previous Message Bruce Momjian 2005-08-12 16:12:17 Re: [HACKERS] data on devel code perf dip