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 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 for Ecological Analysis and Synthesis
>735 State Street, Suite 300, Santa Barbara, CA 93101
>Phone: 805-892-2519, FAX: 805-892-2510
>http://www.nceas.ucsb.edu/~keitt/
>