| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Devinder K Rajput | 2002-10-21 16:45:09 | if statement |
| Previous Message | Josh Berkus | 2002-10-21 15:52:35 | Re: Name switch |