help bug and comment char.

Hi all

In looking for how to do table constraints psql help says:

software=> \h create table
Command: create table
Description: create a new table
Syntax:
        CREATE TABLE class_name
        (attr1 type1 [DEFAULT expression] [NOT NULL], ...attrN)
        [INHERITS (class_name1, ...class_nameN)
        [[CONSTRAINT name] CHECK condition1, ...conditionN] ]
;


But this both does not work, and does not agree with "The Practical SQL
Handbook", the examples of which do work.

Should the syntax not be more like: (constraint inside the main parens)

Command: create table
Description: create a new table
Syntax:
        CREATE TABLE class_name
        (attr1 type1 [DEFAULT expression] [NOT NULL][, ...attrN]
        [,[CONSTRAINT name] CHECK condition1, ...conditionN] ]);

I'm not sure where to put:
        [INHERITS (class_name1, ...class_nameN)
as I've never used it. But I suspect it may need inside the '()' as well,
no?

OH, also, what is / is there, a comment character to use in SQL scripts
feed into psql?

Have a great day
Terry Mackintosh <terry@terrym.com>               http://www.terrym.com
sysadmin/owner                  I'm excited about life! How about YOU!?

Proudly powered by R H Linux 4.2, Apache 1.3.x, PHP 3.x, PostgreSQL 6.x
-----------------------------------------------------------------------
Only if you know where you're going can you get there.