Re: how to set more than two attributes as primary keys in a table - Mailing list pgsql-novice

On Sun, Dec 28, 2003 at 20:21:32 -0800,
  Peggy Go <shatz_go@yahoo.com> wrote:
> Hi!...
>
> Normally, there is only one attribute for the primary
> key but in my table, my primary key is composed of two
> attributes. How do I state this in SQL? What if
> Region_num and Num_Players, combined, should form a
> primary key?
>
CREATE TABLE REGION (
  Region_Num    smallint,
  Num_Players    smallint,
  Player_Num    smallint,
  primary key (Region_Num, Num_Players)
);