From: | Colin Dick <cdick(at)mail(dot)ocis(dot)net> |
---|---|
To: | pgsql-sql(at)postgreSQL(dot)org |
Subject: | Creating table with unique key. |
Date: | 1998-08-05 21:49:13 |
Message-ID: | Pine.LNX.3.96.980805144528.18898A-100000@ocis.ocis.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces pgsql-sql |
> > CREATE TABLE cliente (
> > name varchar(100) UNIQUE NOT NULL,
> > username varchar(8) NOT NULL ,
> > key int4 NOT NULL DEFAULT nextval('key_s') PRIMARY KEY,
> > );
Hi this is from a previous post regarding auto-incrementing. I have that
part working, now I am trying to create a table with a field which will
not be null and will be unique to the rest of table. Is this possible and
what is the correct syntax. I have tried and receeved the following:
CREATE TABLE cust (FileNumber int4 unique not null, CompName varchar(50),
FirstName varchar(50), LastName varchar(50), BirthDate varchar(8), Suite
varchar(5), Address varchar(50), City varchar(20), Province varchar(20),
PostalCode varchar(7), Email varchar(50), HomePhone varchar(14), WorkPhone
varchar(14), FaxPhone varchar(14));
WARN:parser: parse error at or near "unique"
Can someone point me in the right direction. Thanks.
--
Colin Dick
On Call Internet Services
cdick(at)mail(dot)ocis(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Fong | 1998-08-05 22:41:50 | Perl interface |
Previous Message | William McCracken | 1998-08-05 21:09:01 | Accessing PostgreSQL server on linux from windows NT server |
From | Date | Subject | |
---|---|---|---|
Next Message | Brook Milligan | 1998-08-05 22:30:50 | Re: [SQL] What is the recommended machine configuration? |
Previous Message | The Hermit Hacker | 1998-08-05 21:35:13 | Re: [SQL] What is the recommended machine configuration? |