see trigger and estatus select tgname,tgenabled from pg_catalog.pg_trigger
--- On Mon, 6/30/08, kartik <[EMAIL PROTECTED]> wrote: From: kartik <[EMAIL PROTECTED]> Subject: [GENERAL] Query To: pgsql-general@postgresql.org Date: Monday, June 30, 2008, 9:55 AM Hello , I am a beginner for postgresql. I want to activate a constraint for some time and after that I want to deactivate it. Or I want to know whether a particular constraint exists and whether its activated or not. Waiting for yr reply