On Wed, Nov 06, 2002 at 15:18:38 +0100, Huub <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly