Re: The efficient method to create trigger

In response to Jignesh Shah :
> Hi,
>  
> I am new to PostgreSQL. I learnt most of things from postgresql.org site. I
> want to write a trigger for on my table tech_projects such that whenever
> INSERT, UPDATE or DELETE happen on this table, the trigger should get called
> and the updated/deleted row must be added to tech_projects_backup table.
> Moreover, if there are more than one row updated then I don't want to reiterate
> the client-server communication for each row but instead it should process all
> rows at once.

12:32 < akretschmer> ??tablelog
12:32 < rtfm_please> For information about tablelog
12:32 < rtfm_please> see
http://andreas.scherbaum.la/blog/archives/100-Log-Table-Changes-in-PostgreSQL-with-tablelog.html
12:32 < rtfm_please> or http://pgfoundry.org/projects/tablelog/

Regards, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net