From: lynch@lscorp.com
To: Colin Dick <cdick@mail.ocis.net>
To: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] Creating table with unique key.
Date: Wed, 5 Aug 1998 18:42:03 -0500
Message-ID: <v02140b58b1ee55140c5b@[207.152.64.133]> (raw)
At 2:49 PM 8/5/98, Colin Dick 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,
There should be no comma (,) in the last field description.
>> > );
>
>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.
www.postgresql.org/docs/man/create_table.1.html does not seem to allow for
any spiffy keywords like UNIQUE nor PRIMARY KEY... at least not if I'm
understanding it properly.
Disclaimer: I think the docs are wrong, not that at least one of them
won't work.
--
--
-- "TANSTAAFL" Rich lynch@lscorp.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: lynch@lscorp.com, cdick@mail.ocis.net
Subject: Re: [SQL] Creating table with unique key.
In-Reply-To: <v02140b58b1ee55140c5b@[207.152.64.133]>
References: <v02140b58b1ee55140c5b@[207.152.64.133]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox