Re: how to create secondary key!!

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