Hi!

Can anyone help me with creating a History table? I need posgre to insert changes of a table in a history table by triggers.

For example:

tbl_customers:

customer_id
customer_name

this table will have a history table wich would look like this

tbl_customers_h:

customer_id
customer_name
operation
user
timestamp

I need an after trigger wich fills the history table on update, insert or delete. An example would be great!!!