On Tue, 16 Sep 2003, Rod Taylor wrote: > > I'm not sure how to add constraints to already existing tables, so you > > might wanna do this in a test table, move your data over, then rename > > tables to swap in the new table. > > ALTER TABLE ... ADD CONSTRAINT For some unknown reason, that part of the alter table under \h eluded me when I was doing this... Well, it WAS like 6am, and I hadn't had any coffee. Think I'll take a nap under my desk now. :-)