Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 632FA477164
	for <pgsql-sql@postgresql.org>; Thu,  7 Nov 2002 09:55:40 -0500 (EST)
Received: from wolff.to (unknown [66.93.197.35])
	by postgresql.org (Postfix) with SMTP id 8FAE2476D6C
	for <pgsql-sql@postgresql.org>; Thu,  7 Nov 2002 09:25:53 -0500 (EST)
Received: (qmail 7293 invoked by uid 500); 7 Nov 2002 14:35:30 -0000
Date: Thu, 7 Nov 2002 08:35:30 -0600
From: Bruno Wolff III <bruno@wolff.to>
To: Huub <v.niekerk@freeler.nl>
Cc: pgsql-sql@postgresql.org
Subject: Re: primary keys
Message-ID: <20021107143530.GB6881@wolff.to>
Mail-Followup-To: Huub <v.niekerk@freeler.nl>,
	pgsql-sql@postgresql.org
References: <aqb8b8$1k8v$1@news.hub.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <aqb8b8$1k8v$1@news.hub.org>
User-Agent: Mutt/1.3.25i
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200211/99
X-Sequence-Number: 10241

On Wed, Nov 06, 2002 at 15:18:38 +0100,
  Huub <v.niekerk@freeler.nl> wrote:
> Hi,
> 
> I want to create a table which has 2 columns, and both columns have to 
> be primary key (or: together they are the primary key). How can I do 
> this using SQL? Using pgAdminII for Postgres7.2.2 on RH8.

You can use a PRIMARY KEY table constraint. You can the SQL command
documentation for the CREATE TABLE command.