audit trail implementation

Dear All

I need your inputs, How to implement audit trail
using postgresql trigger or another functions, is there triggers/functions to track
changes in existing or newly created data in tables.

Thank u in Advance.

You can use log_statement parameter in PostgreSQL.

If you enable this parameter then, PG log the information in log file and you can write your own script which will take out the information from Logfile for auditing purpose.

Dear All,

Thanks for u r inputs.
apart from postgres log file, is there any other alternative method to track changes in data.