Re: primary keys - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: primary keys
Date
Msg-id 20021107143530.GB6881@wolff.to
Whole thread Raw
In response to primary keys  (Huub <v.niekerk@freeler.nl>)
List pgsql-sql
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.


pgsql-sql by date:

Previous
From: Christoph Haller
Date:
Subject: Re: how to get the source table & field name of a view field
Next
From: "Sangeetha Rao"
Date:
Subject: Re: primary keys