Thread: Adding audit trail fields and triggers to all tables
I need to add the following fields to all tables to existing 8.1 database: created timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL, createdby text DEFAULT CURRENT_USER, updated timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL, updatedby text -- current_user who last updates this record I need also to add triggers so that updated and updatedby fields ae automatically set when record is changed. Where to find script which implements this ? Andrus.
On Wed, Feb 14, 2007 at 06:38:40PM +0200, Andrus wrote: > I need to add the following fields to all tables to existing 8.1 database: Why redo work? <http://pgfoundry.org/projects/tablelog/> <http://www.postgresql.org/docs/current/static/plpgsql-trigger.html#PLPGSQL-TRIGGER-AUDIT-EXAMPLE> Cheers, D > > > created timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL, > > createdby text DEFAULT CURRENT_USER, > > updated timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL, > > updatedby text -- current_user who last updates this record > > > I need also to add triggers so that updated and updatedby fields ae > automatically set when record is changed. > > > Where to find script which implements this ? > > > Andrus. > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend -- David Fetter <david@fetter.org> http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter Remember to vote!