| From: | LeoDeBeo <leodebeo(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-docs(at)postgresql(dot)org |
| Subject: | create table |
| Date: | 2001-04-29 19:32:15 |
| Message-ID: | 9chq93$21vm$1@news.tht.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
can anybody explain me the syntax of Create Table documentation??
CREATE [ TEMPORARY | TEMP ] TABLE table (
column type
[ NULL | NOT NULL ] [ UNIQUE ] [ DEFAULT value ]
[ column_constraint_clause | PRIMARY KEY } [ ... ] ]
[ , ... ]
[ , PRIMARY KEY ( column [, ... ] ) ]
[ , CHECK (condition) ]
[ , table_constraint_clause ]
) [ INHERITS ( inherited_table [, ... ] ) ]
i don't understand what the curly brace means after PRIMARY KEY (where is
the other matching brace? ). It must have something to do with the fact
that a 'column type' pair ( with options ) can occur more than once, but is
this syntax right?
i also don't understand what the [ ... ] and [, ... ] means. I do know that
brackets denote options and | alternatives.
tx
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roberto Mello | 2001-04-29 20:39:06 | Re: create table |
| Previous Message | Raoul Callaghan | 2001-04-28 22:54:47 | perlDBD::pg error! Please help (have all details in post) |