Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A2C0D475E8D for ; Wed, 28 Aug 2002 20:18:38 -0400 (EDT) Received: from fedk0905.FERRING.COM (fedk0905.ferring.com [213.237.141.20]) by postgresql.org (Postfix) with ESMTP id D72CC475C66 for ; Wed, 28 Aug 2002 20:18:37 -0400 (EDT) Received: from fedk0005.Fic.ferring.com (unverified) by fedk0905.FERRING.COM (Content Technologies SMTPRS 4.2.1) with ESMTP id for ; Thu, 29 Aug 2002 02:18:38 +0200 Received: from ferring.com (10.20.100.63 [10.20.100.63]) by fedk0005.Fic.ferring.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id RYXHMPP6; Thu, 29 Aug 2002 02:18:49 +0200 Message-ID: <3D6D6798.70706@ferring.com> Date: Wed, 28 Aug 2002 17:15:20 -0700 From: Kemin Zhou User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.1b) Gecko/20020722 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: trigger viewing Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/410 X-Sequence-Number: 9256 Dear Friends, Some times when we create foreign keys we find these type of things after \d table Triggers: RI_ConstraintTrigger_39656710, RI_ConstraintTrigger_39656716 These trigger could be this table using foreigin keys from other table or vis versa. I don't know how to figure out what are defined in the triggers. Is there any things like \d trigger ? Kemin