compound key - Mailing list pgsql-sql

From MESZAROS Attila
Subject compound key
Date
Msg-id Pine.LNX.3.96.990319214553.24189A-100000@chiara.csoma.elte.hu
Whole thread Raw
Responses Re: [SQL] compound key  ("Brett W. McCoy" <bmccoy@lan2wan.com>)
List pgsql-sql
Hi,

I have seen the following stucture in AdabasD:
create table AttributeNames (
   id           integer not null,
   name         varchar(200),
   classId      integer not null
);
alter table AttributeNames add primary key (id,classId);

I know, I can't create "compound key" using "alter table", but is there
any way to create one ?

thanx,
Attila


pgsql-sql by date:

Previous
From: David Martinez Cuevas
Date:
Subject: Re: [SQL] Re: Stuck on SQL - Any Takers?
Next
From: "Brett W. McCoy"
Date:
Subject: Re: [SQL] compound key