Re: primary keys

Hi,

For example you can do something like that:

CREATE TABLE "try" (
"field1" TEXT NOT NULL,
"field2" INT4 NOT NULL,
"field3" TEXT, PRIMARY KEY (field1, field2));

**************************************
Rachel(dot)Vaudron(at)lazaret(dot)unice(dot)fr
Laboratoire de prehistoire du Lazaret
33 bis bd Franck Pilatte 06300 Nice
tel:04-92-00-17-37/fax:04-92-00-17-39
******** Windows a bug's life ********

On Wed, 6 Nov 2002, Huub 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.
>
> Thanks
>
> Huub
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>