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.Vaudron@lazaret.unice.fr
Laboratoire de prehistoire du Lazaret33 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
>