PRIMARY KEY and UNIQUE

From: Erwin Ambrosch <erwin(dot)ambrosch(at)ebutec(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PRIMARY KEY and UNIQUE
Date: 2002-02-14 13:27:22
Message-ID: 200202141330.g1EDUhM26841@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 Doug McNaught 2002-02-14 13:43:14 Re: Error trying to restore db with blobs
Previous Message Evandro 2002-02-14 12:56:12 Error trying to restore db with blobs