Re: [GENERAL] TEXT and BLOBS

2000-11-10 Thread Ben Souther
- Original Message - From: Martin A. Marques <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 08, 2000 8:36 AM Subject: [GENERAL] TEXT and BLOBS > I want to find out how confused I am. ;-) > I'm testing something on a Postgres 7.0.2 database. I made a small table wi

[GENERAL] RE: Foreign key

2000-10-27 Thread Ben Souther
Never mind..found it.   ALTER TABLE distributors ADD CONSTRAINT distfk FOREIGN KEY (col_name) REFERENCES table_name(col_name) MATCH FULL  

[GENERAL] Foreign keys, adding to table.

2000-10-27 Thread Ben Souther
Quick easy one: Could someone please tell me the syntax for adding a foreign key constraint to an existing row in an existing table. Thanks.