Re: primary keys

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Huub <v(dot)niekerk(at)freeler(dot)nl>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: primary keys
Date: 2002-11-07 14:35:30
Message-ID: 20021107143530.GB6881@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wed, Nov 06, 2002 at 15:18:38 +0100,
Huub <v(dot)niekerk(at)freeler(dot)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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tomasz Myrta 2002-11-07 14:49:06 Re: primary keys
Previous Message Christoph Haller 2002-11-07 14:35:27 PLpgSQL FOR IN EXECUTE question