Re: how to create secondary key!! - Mailing list pgsql-novice

From Josh Berkus
Subject Re: how to create secondary key!!
Date
Msg-id web-1793288@davinci.ethosmedia.com
Whole thread Raw
In response to how to create secondary key!!  ("Nelson Yong" <nelsonyong@ipmuda.com.my>)
List 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

pgsql-novice by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: Name switch
Next
From: "Devinder K Rajput"
Date:
Subject: if statement