pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedPrimary Key Help !
2+ messages / 2 participants
[nested] [flat]
* Primary Key Help !
@ 2002-10-05 05:19 Waheed Rahuman <waheed@digiba.com>
2002-12-12 08:04 ` Re: Primary Key Help ! Ludwig Lim <lud_nowhere_man@yahoo.com>
0 siblings, 1 reply; 2+ messages in thread
From: Waheed Rahuman @ 2002-10-05 05:19 UTC (permalink / raw)
To: pgsql-sql
Hi Greetings
Friends please help me in setting the primary key
in a table how many primary key i can create.
In MS access its only 10 column can be made into primary key !.
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
Thank you for your reply
Regards
Waheed
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Primary Key Help !
2002-10-05 05:19 Primary Key Help ! Waheed Rahuman <waheed@digiba.com>
@ 2002-12-12 08:04 ` Ludwig Lim <lud_nowhere_man@yahoo.com>
0 siblings, 0 replies; 2+ messages in thread
From: Ludwig Lim @ 2002-12-12 08:04 UTC (permalink / raw)
To: Waheed Rahuman <waheed@digiba.com>; +Cc: pgsql-sql
--- 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-12-12 08:04 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-10-05 05:19 Primary Key Help ! Waheed Rahuman <waheed@digiba.com>
2002-12-12 08:04 ` Ludwig Lim <lud_nowhere_man@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox