From: Roberto Mello <rmello@cc.usu.edu>
To: LeoDeBeo <leodebeo@hotmail.com>
Cc: pgsql-docs@postgresql.org
Subject: Re: create table
Date: Sun, 29 Apr 2001 14:39:06 -0600
Message-ID: <20010429143906.A27567@cc.usu.edu> (raw)
In-Reply-To: <9chq93$21vm$1@news.tht.net>
References: <9chq93$21vm$1@news.tht.net>
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.nethttp://www.sdl.usu.edu - Space Dynamics Lab, Developer
Connection Attempt #172 ..<ring>...CONNECT 300.... <CLICK!>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: rmello@cc.usu.edu, leodebeo@hotmail.com
Subject: Re: create table
In-Reply-To: <20010429143906.A27567@cc.usu.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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