Re: Primary Key Help !

--- Waheed Rahuman <waheed(at)digiba(dot)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