doubt - Mailing list pgsql-admin

From sathish
Subject doubt
Date
Msg-id 40C97EE7.8030901@ceedees.com
Whole thread Raw
List pgsql-admin
dear groups,
   i have a doubt in sql,
   i have a table staff_skills in which i have set a table level
constraint to create a primary key of two fields .
   so 'name' and 'skill' combinedly forms a primary key.
   now the issue is in another table i have only 'name' field and i want
to create a foreign key constraint which refers the staff_skills table's
'name' field only.
  staff_skills (table) - name,skill,ability  (columns)   ---  primary
key(name,skill)
  staff_xxxx (table) - name,x,y,z            (columns)  ---   foreign
key(name) references staff_skills(name).
  how to do the above?
  your immediate reply will be helpful
yours sincerely
SathishKumar.S


pgsql-admin by date:

Previous
From: Kurt Watson
Date:
Subject: Re: Mac OS 10.3.4: pgsql fails to launch at boot
Next
From: Gavin Thompson
Date:
Subject: Re: pg_stat tables empty