viewing/altering the "ON DELETE CASCADE" constraint

Hello All-

I'm sure this is a FAQ, but I cannot find anything in the docs that
directly addresses this.

How can I determine if a column 1) has a foreign key constraint, and 2)
if that fkey constraint includes "ON DELETE CASCADE"? I've tried the
various "\d"-type commands in psql to no avail.

Finally, assuming you have a column that *has* a fkey constraint, but
not the additional "ON DELETE CASCADE" portion, how would you go about
adding "ON DELETE CASCADE" to the column?

TIA,
-Jon

PS: PostgreSQL v7.2.1

PSS: I'm happy to receive a RTFM, if you would be so kind as to also
point to where in the FM these things might be...

PSSS: Searching the mailing lists on http://archives.postgresql.org/ is
returning an error message: could not connect to server: Connection
refused Is the server running on host db.postgresql.org and accepting
TCP/IP connections on port 5433?

--

-**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*---
Jon Lapham
Extracta Moléculas Naturais, Rio de Janeiro, Brasil
email: lapham(at)extracta(dot)com(dot)br web: http://www.extracta.com.br/
***-*--*----*-------*------------*--------------------*---------------