Re: typo in psql's help
От | Bruce Momjian |
---|---|
Тема | Re: typo in psql's help |
Дата | |
Msg-id | 200105071606.f47G6Rv09779@candle.pha.pa.us обсуждение исходный текст |
Ответ на | typo in psql's help (Vince Vielhaber <vev@michvhf.com>) |
Ответы |
Re: typo in psql's help
Re: typo in psql's help |
Список | pgsql-hackers |
> postgresql=> \h create table > Command: CREATE TABLE > Description: Creates a new table > Syntax: > CREATE [ TEMPORARY | TEMP ] TABLE table ( > column type > [ NULL | NOT NULL ] [ UNIQUE ] [ DEFAULT value ] > [column_constraint_clause | PRIMARY KEY } [ ... ] ] > ^ > This should be a ] | Vince, I can't find this anywhere. What version is this? I bet we already fixed it. In fact, I think I remember seeing the fix a while ago. My pgsql \h create table shows: --------------------------------------------------------------------------- CREATE [ TEMPORARY | TEMP ] TABLE table_name ( { column_name type [ column_constraint [ ... ] ] | table_constraint} [, ... ] ) [ INHERITS ( parent_table [, ... ] ) ] where column_constraint can be: [ CONSTRAINT constraint_name ] { NOT NULL | NULL | UNIQUE | PRIMARY KEY | DEFAULT value | CHECK (condition) | REFERENCES table [ ( column ) ] [ MATCH FULL| MATCH PARTIAL ] [ ON DELETE action ] [ ON UPDATE action ] [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED |INITIALLY IMMEDIATE ] } and table_constraint can be: [ CONSTRAINT constraint_name ] { UNIQUE ( column_name [, ... ] ) | PRIMARY KEY ( column_name [, ... ] ) | CHECK ( condition ) | FOREIGN KEY ( column_name[, ... ] ) REFERENCES table [ ( column [, ... ] ) ] [ MATCH FULL | MATCH PARTIAL ] [ ON DELETE action ] [ ONUPDATE action ] [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ] } -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
В списке pgsql-hackers по дате отправления: