almost,
ALTER TABLE
cust# the table to be alteredyes
ADD CONSTRAINT
fk_cust_bd_id # name of the constraint (see
tgconstrname column in pg_trigger)
FOREIGN KEY
(bd_id) # column in cust to be FK'd to bil
Hmmm... I got it to work, but using a slightly different syntax. Let me
see if I understand your example:
ALTER TABLE
cust# the table to be altered
ADD CONSTRAINT
fk_cust_bd_id # the column in cust to add the constraint?
FOREIGN KEY
(bd_id)
alter table cust add constraint fk_cust_bd_id foreign key (bd_id)
references bill_dist (bd_id);
At 12:57 PM 7/26/00 -0700, Timothy H. Keitt wrote:
>Can someone give an example of how to add a foreign key constraint to an
>existing table? (Pgsql and the man page differ and neither syntax se
Can someone give an example of how to add a foreign key constraint to an
existing table? (Pgsql and the man page differ and neither syntax seems
to work.)
I've tried:
alter table mytable add constraint col foreign key references reftable
with no luck.
Tim
--
Timothy H. Keitt
National Center
