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 by GCC 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: [EMAIL PROTECTED] http://www.pop4.net
56K Nationwide Dialup from $16.00/mo at Pop4 Networking
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
