Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28])
	by postgresql.org (8.11.3/8.11.1) with SMTP id f44J3JA01173
	for <pgsql-sql@postgresql.org>; Fri, 4 May 2001 15:03:19 -0400 (EDT)
	(envelope-from pgsql-sql-owner@postgresql.org)
Received: from news.tht.net (news.hub.org [216.126.91.242])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f3TJuD313146
	for <pgsql-sql@postgresql.org>; Sun, 29 Apr 2001 15:56:14 -0400 (EDT)
	(envelope-from news@news.tht.net)
Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id
 f3TJZ6R67599
	for pgsql-sql@postgresql.org; Sun, 29 Apr 2001 15:35:06 -0400 (EDT)
	(envelope-from news)
From: LeoDeBeo <leodebeo@hotmail.com>
X-Newsgroups: comp.databases.postgresql.sql
Subject: create table
Date: Sun, 29 Apr 2001 21:34:29 +0200
Organization: Hub.Org Networking Services (http://www.hub.org)
Lines: 22
Message-ID: <9chqd9$21vm$2@news.tht.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7Bit
X-Complaints-To: scrappy@hub.org
User-Agent: KNode/0.4
To: pgsql-sql@postgresql.org
X-Archive-Number: 200105/26
X-Sequence-Number: 2824

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