On Mon, 7 May 2001, Bruce Momjian wrote:
> > 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.
Yeah, I got a note from Peter saying it was fixed in 7.1. Silly me, I
thought hub was running 7.1, psql must be 7.0.x.
---
postgresql=> select version(); version
-------------------------------------------------------------------PostgreSQL 7.1 on i386-unknown-freebsd4.2, compiled
byGCC 2.95.2
(1 row)
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 } [ ... ] ] [, ... ] [, PRIMARY KEY ( column [, ...] ) ] [, CHECK (
condition) ] [, table_constraint_clause ] ) [ INHERITS ( inherited_table [, ...] ) ]
---
as just seen on hub a few minutes ago.
Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net 56K Nationwide Dialup from $16.00/mo
atPop4 Networking Online Campground Directory http://www.camping-usa.com Online Giftshop Superstore
http://www.cloudninegifts.com
==========================================================================