PRIMARY KEY and UNIQUE

From: Erwin Ambrosch <ambre(at)ebutec(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PRIMARY KEY and UNIQUE
Date: 2002-02-14 15:06:35
Message-ID: 200202141509.g1EF9uM27132@email.ebutec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a such a table.

CREATE TABLE int_article (
name VARCHAR(12) UNIQUE
headline TEXT,
summary TEXT,
main TEXT,
footer TEXT,
PRIMARY KEY (name)
);

Is the UNIQUE constraint neccessary, because if have specified the column
name to be the primary key.

Thanks in advance
Erwin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Darren Ferguson 2002-02-14 15:29:09 Re: PRIMARY KEY and UNIQUE
Previous Message Tom Lane 2002-02-14 14:48:59 Re: Error trying to restore db with blobs