primary key question - Mailing list pgsql-general

From Huub
Subject primary key question
Date
Msg-id aqd2t4$1g4b$1@news.hub.org
Whole thread Raw
Responses Re: primary key question  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Hi,

Reading the online manual it doesn't get clear to me: can I or can't I
define a primary key containing 2 columns, e.g. like:

create table <name> (column1 char(10) not null, column2 char(20) not
null, primary key (column1, column2))

Thanks

Huub


pgsql-general by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: CURRENT_TIME
Next
From: Achilleus Mantzios
Date:
Subject: Re: [SQL] Problem: Referential Integrity Constraints lost