Re: Triggers - Mailing list pgsql-general

From Richard Huxton
Subject Re: Triggers
Date
Msg-id 41AAF080.8020607@archonet.com
Whole thread Raw
In response to Triggers  (Jamie Deppeler <jamie@doitonce.net.au>)
List pgsql-general
Jamie Deppeler wrote:
> Hi,
>
> Just doing some testing at the moment and trying to make a trigger that
> consists of a insert statement which as a result of an sql querty!

Look into using EXECUTE - it accepts a string expression and executes
it. Don't forget to use the quote_xxx() functions to quote identifiers etc.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Table and Field Schemas
Next
From: "Gevik Babakhani"
Date:
Subject: Re: tool for postgresql