On 05/21/2014 02:54 AM, Khangelani Gama wrote:
Hi
I have a postgres 9 database, inside this database I need to create a
new table called *center_changed* that gets inserted by any change that
take place in a table called *center*. So I need to create trigger to do
this.
*Example: *
Table name*: center*(c_cde, c_dsc, ops_cde, grp_cde);
Now on the table called *center , *I need to create an INSERT and UPDATE
trigger will insert the *c_cde * of the inserted or updated *center*
into the *center_changed* table
Please help me
I have this syntax below, but please help me with the overall query.
CREATE TRIGGER check_center
BEFORE INSERT OR UPDATE
ON *cente*r FOR EACH ROW
EXECUTE PROCEDURE check_center_changes();
See here:
http://www.postgresql.org/docs/9.3/interactive/plpgsql-trigger.html
Example 40-4. A PL/pgSQL Trigger Procedure For Auditing
Thanks
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
