Primary and Foreign Key?
| От | A. Banks |
|---|---|
| Тема | Primary and Foreign Key? |
| Дата | |
| Msg-id | KBEKKNMFLELKGIADDEPEOELICAAA.abanks@insightbb.com обсуждение |
| Ответы |
Re: Primary and Foreign Key?
Re: Primary and Foreign Key? |
| Список | pgsql-novice |
I have the following related tables: PEOPLE -------------- peopleid pkey, name, etc GROUPS ------------- groupid pkey, description, etc PEOPLEGROUPS ------------------- peopleid pkey/fkey, groupid pkey/fkey What is the CORRECT way (in Postgres) to define the PEOPLEGROUPS table so that it has both the double primary key AND still acts as a foreign key for people.peopleid and groups.groupid? Can i specify both or is this not necessary? Any suggestions would be appreciated. Thanks! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.3/107 - Release Date: 9/20/2005
В списке pgsql-novice по дате отправления: