Cant define PRIMARY_KEY?
xebcam opened this issue · 2 comments
xebcam commented
Sorry but I can't find a way to define an attribute as a PRIMARY_KEY is this a bug or maybe I'm missing something in the table generation dialog? I dont see any option to define a primary key here.
I would greatly appreciate if some one could tell me how to define primary keys.
I'm using PostgreSQL.
momeni commented
You can define a primary key as follows:
- Switch to the Indexes tab,
- Type a custom name for the PK index (e.g., student_pk) in the Name text box,
- Select the student_id column from the Attribute combo-box,
- Press the NEW button (right of the Attribute combo-box),
- Select the Index is primary key radio button,
- Press the Update button,
- Press the Ok button (the added primary key will be designated using a key icon).
xebcam commented
Thanks.