Re: Primary Key Help !

--- Waheed Rahuman <waheed@digiba.com> wrote:
> Hi Greetings
> My question is How many primary key i can assign in
> a PostGresql Table
> 
> Rowid        |      Parent1       |      Parent2    
>   |      Parent3       |      Parent4       |     
> Parent5       |      Parent6       |      Parent7   
>    |      Parent8       |      Parent9       |     
> Parent10      |
> 
> Here i want to make Parent1.........Parent 10 as
> Primary Key  and ...this parent field i want to make
> it more than 10 fields....if i try to make primary
> key more than 10 fields in ms access its say not
> possible so please let me know how i can do that in
> psql. or if there is an alternative way...i will be
> glad
 Assuming that you have already created the table try
doing the following:
  ALTER TABLE <table> ADD CONSTRAINT <constraint
name> PRIMARY KEY (parent1,parent2....,parent10);

Hope that helps,

ludwig


__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com