primary key question

From: Huub <v(dot)niekerk(at)freeler(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: primary key question
Date: 2002-11-07 06:57:55
Message-ID: aqd2t4$1g4b$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Achilleus Mantzios 2002-11-07 07:33:21 Re: [SQL] Problem: Referential Integrity Constraints lost
Previous Message Thomas Lockhart 2002-11-07 06:50:00 Re: CURRENT_TIME