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));
**************************************
[EMAIL PROTECTED]
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
>
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
