Uz.ytkownik Huub napisa?:> 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.
Dependent on what you need:
1) you can create primary key based on 2 fields
2) you can't create 2 primary keys - but you can create primary key on
first field and create unique index on second one.
Tomasz Myrta