This is a discussion on CREATE TABLE synopsis within the pgsql Hackers forums, part of the PostgreSQL category; --> The CREATE TABLE synopsis shows this: CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| The CREATE TABLE synopsis shows this: CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name ( { column_name data_type [ DEFAULT default_expr ] [ column_constraint [ ... ] ] | table_constraint | LIKE parent_table [ { INCLUDING | EXCLUDING } DEFAULTS ] } [, ... ] ) However, we now allow zero-column tables, so it should actually be CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name ( [ column_name data_type [ DEFAULT default_expr ] [ column_constraint [ ... ] ] | table_constraint | LIKE parent_table [ { INCLUDING | EXCLUDING } DEFAULTS ] ] [, ... ] ) Right? -- Alvaro Herrera (<alvherre[a]alvh.no-ip.org>) ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster |
| ||||
| Right, fixed in create_table.sgml. I don't think it is any other place. --------------------------------------------------------------------------- Alvaro Herrera wrote: > The CREATE TABLE synopsis shows this: > > CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name ( > { column_name data_type [ DEFAULT default_expr ] [ column_constraint [ ... ] ] > | table_constraint > | LIKE parent_table [ { INCLUDING | EXCLUDING } DEFAULTS ] } [, ... ] > ) > > However, we now allow zero-column tables, so it should actually be > > CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name ( > [ column_name data_type [ DEFAULT default_expr ] [ column_constraint [ ... ] ] > | table_constraint > | LIKE parent_table [ { INCLUDING | EXCLUDING } DEFAULTS ] ] [, ... ] > ) > > Right? > > -- > Alvaro Herrera (<alvherre[a]alvh.no-ip.org>) > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly |