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 with

[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.

[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