From: | Roberto Mello <rmello(at)cc(dot)usu(dot)edu> |
---|---|
To: | LeoDeBeo <leodebeo(at)hotmail(dot)com> |
Cc: | pgsql-docs(at)postgresql(dot)org |
Subject: | Re: create table |
Date: | 2001-04-29 20:39:06 |
Message-ID: | 20010429143906.A27567@cc.usu.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
On Sun, Apr 29, 2001 at 09:32:15PM +0200, LeoDeBeo wrote:
> 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
Means that you can optionally have several others of the prior.
PRIMARY KEY(column, column, column...)
> that a 'column type' pair ( with options ) can occur more than once, but is
> this syntax right?
AFAICS yes.
-Roberto
--
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net
http://www.sdl.usu.edu - Space Dynamics Lab, Developer
Connection Attempt #172 ..<ring>...CONNECT 300.... <CLICK!>
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2001-04-29 22:19:46 | Re: PostgreSQL Feature Sheet |
Previous Message | LeoDeBeo | 2001-04-29 19:32:15 | create table |