Skip site navigation (1) Skip section navigation (2)

Re: how to create secondary key!!

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: "Nelson Yong" <nelsonyong(at)ipmuda(dot)com(dot)my>,pgsql-novice(at)postgresql(dot)org
Subject: Re: how to create secondary key!!
Date: 2002-10-21 15:54:45
Message-ID: web-1793288@davinci.ethosmedia.com (view raw or flat)
Thread:
Lists: pgsql-novice
Nelson,

> i'm using pgAdmin II as the remote client, after importing the text
> file 
> to postgresql database; i'm start trying to find the way to create
> the 
> primary key and secondary key. unfortunely, under the pgAdmin II
> there 
> aren't any tools to do that. However i managed to fine the way to
> create 
> the primary key by using the index function but i still cannot create
> the 
> secondary key in my database. please advise me!

As there is no such thing as a "secondary key" in SQL, you are probably
referring to something else.   Can you explain what you mean by
"secondary key"?   Perhaps a "Foriegn Key" or a "Unique Index"?

-Josh Berkus

In response to

pgsql-novice by date

Next:From: Devinder K RajputDate: 2002-10-21 16:45:09
Subject: if statement
Previous:From: Josh BerkusDate: 2002-10-21 15:52:35
Subject: Re: Name switch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group