Re: [SQL] Creating table with unique key.

Hello Colin,

mercoledì, 5 agosto 98, you wrote:

>> > CREATE TABLE cliente (
>> > name varchar(100) UNIQUE NOT NULL,
>> > username varchar(8) NOT NULL ,
>> > key int4 NOT NULL DEFAULT nextval('key_s') PRIMARY KEY,
>> > );

CD> Hi this is from a previous post regarding auto-incrementing. I have that
CD> part working, now I am trying to create a table with a field which will
CD> not be null and will be unique to the rest of table. Is this possible and
CD> what is the correct syntax. I have tried and receeved the following:

CD> CREATE TABLE cust (FileNumber int4 unique not null, CompName varchar(50),
CD> FirstName varchar(50), LastName varchar(50), BirthDate varchar(8), Suite
CD> varchar(5), Address varchar(50), City varchar(20), Province varchar(20),
CD> PostalCode varchar(7), Email varchar(50), HomePhone varchar(14), WorkPhone
CD> varchar(14), FaxPhone varchar(14));
CD> WARN:parser: parse error at or near "unique"

CD> Can someone point me in the right direction. Thanks.

CD> --
CD> Colin Dick
CD> On Call Internet Services
CD> cdick(at)mail(dot)ocis(dot)net

The syntax is correct for v6.3.2 and it works for me, maybe you have
an older release of PostgreSQL.

Best regards,
Jose' mailto:sferac(at)bo(dot)nettuno(dot)it