Re: Creating a trigger on n tables?

From: Richard Huxton <dev(at)archonet(dot)com>
To: Bjørn T Johansen <btj(at)havleik(dot)no>
Cc: PostgreSQL - General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Creating a trigger on n tables?
Date: 2006-04-10 08:41:33
Message-ID: 443A1A3D.9060307@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bjørn T Johansen wrote:
> Is there an easier way to create the same trigger for n tables or do
> I need to run create trigger n times?

You'll need to run CREATE TRIGGER several times I'm afraid. You might be
able to wrap this in a function if you'd like though.

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2006-04-10 08:46:15 Re: ANALYZE for a schema
Previous Message Vittorio 2006-04-10 08:40:21 Updating & inserting in one shot!