Postgres Pro
Downloads
Home   >   mailing lists

Re: Creating a trigger on n tables? - Mailing list pgsql-general

From Richard Huxton
Subject Re: Creating a trigger on n tables?
Date
Msg-id 443A1A3D.9060307@archonet.com
Whole thread Raw
In response to Creating a trigger on n tables?  (Bjørn T Johansen <btj@havleik.no>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "surabhi.ahuja"
Date:
Subject: Re: postmaster going down own its on
Next
From: Richard Huxton
Date:
Subject: Re: ANALYZE for a schema