pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedcreate table
2+ messages / 2 participants
[nested] [flat]
* create table
@ 2001-04-29 19:32 LeoDeBeo <leodebeo@hotmail.com>
2001-04-29 20:39 ` Re: create table Roberto Mello <rmello@cc.usu.edu>
0 siblings, 1 reply; 2+ messages in thread
From: LeoDeBeo @ 2001-04-29 19:32 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: create table
2001-04-29 19:32 create table LeoDeBeo <leodebeo@hotmail.com>
@ 2001-04-29 20:39 ` Roberto Mello <rmello@cc.usu.edu>
0 siblings, 0 replies; 2+ messages in thread
From: Roberto Mello @ 2001-04-29 20:39 UTC (permalink / raw)
To: LeoDeBeo <leodebeo@hotmail.com>; +Cc: 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!>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-04-29 20:39 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-04-29 19:32 create table LeoDeBeo <leodebeo@hotmail.com>
2001-04-29 20:39 ` Roberto Mello <rmello@cc.usu.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox