Postgres Pro
Downloads
Home   >   mailing lists

PRIMARY KEY and UNIQUE - Mailing list pgsql-general

From Erwin Ambrosch
Subject PRIMARY KEY and UNIQUE
Date
Msg-id 200202141330.g1EDUhM26841@email.ebutec.at
Whole thread Raw
Responses Re: PRIMARY KEY and UNIQUE
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: virka prasetia
Date:
Subject: building odb postgreSQL
Next
From: "Rishabh Gupta"
Date:
Subject: data mining or statistical analysis with postgresql