Re: [HACKERS] 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] ]);

Fixed.


> 
> 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?

-- is the comment character.  Man sql says:

---------------------------------------------------------------------------

Comments
       A comment is an arbitrary sequence of characters following
       double dashes up to the end of the line.  We also  support
       double-slashes as comments, e.g.:
       -- This is a standard SQL comment
       // And this is another supported comment style, like C++

       We also support C-style comments, e.g.:
       /* multi
          line
          comment */



-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026