From: Ludwig Lim <lud_nowhere_man@yahoo.com>
To: Waheed Rahuman <waheed@digiba.com>
Cc: PostgreSQL Mailing List <pgsql-sql@postgresql.org>
Subject: Re: Primary Key Help !
Date: Thu, 12 Dec 2002 00:04:17 -0800 (PST)
Message-ID: <20021212080417.56978.qmail@web80306.mail.yahoo.com> (raw)
In-Reply-To: <004601c26c2e$ba5c9400$0305a8c0@yellow>
--- 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: lud_nowhere_man@yahoo.com, waheed@digiba.com
Subject: Re: Primary Key Help !
In-Reply-To: <20021212080417.56978.qmail@web80306.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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