From: | sathish <sathish(at)ceedees(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | doubt |
Date: | 2004-06-11 09:44:07 |
Message-ID: | 40C97EE7.8030901@ceedees.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-jdbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Schmitz | 2004-06-11 11:46:36 | pg_clog after crash |
Previous Message | lise chhay | 2004-06-11 09:20:30 | how to test the server webauth on mandrake |
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Moses | 2004-06-12 13:52:08 | Simon Moses Qs |
Previous Message | Dave Cramer | 2004-06-10 16:36:02 | Re: [JDBC] Trouble with locking tables - reg. |