D-Net

		addLogTable(database, table);

	public void addLogTable(final String database, final String table) throws DatabaseException {

		verifyParameters(database, table);

		JdbcTemplate jdbcTemplate = jdbcTemplateFactory.createJdbcTemplate(database);

		if (!isLoggedTable(jdbcTemplate, table)) {

			jdbcTemplate.update(getSQLFromTemplate("removeLogTable", database, table, null));

			jdbcTemplate.update(getSQLFromTemplate("addLogTable", database, table, null));

			log.info("Added logs of table " + table);

		}

	}

		removeLogTable(database, table);

	public void removeLogTable(final String database, final String table) throws DatabaseException {

		verifyParameters(database, table);

		JdbcTemplate jdbcTemplate = jdbcTemplateFactory.createJdbcTemplate(database);

		if (isLoggedTable(jdbcTemplate, table)) {

			jdbcTemplate.update(getSQLFromTemplate("removeLogTable", database, table, null));

			log.info("Removed logs of table " + table);

		}

	}

CREATE TABLE ${table}_log (

	${idField} VARCHAR(2048),

	operation VARCHAR(10),

	date TIMESTAMP DEFAULT current_timestamp,

	id SERIAL,

	status VARCHAR(10) DEFAULT ''

);

INSERT INTO ${table}_log SELECT ${idField}, 'insert', current_timestamp from ${table};

create or replace function notify_insert_${table}() returns trigger as $$

  begin

    insert into ${table}_log values (NEW.${idField}, 'insert');

    return NEW;

  end;

$$

language plpgsql volatile;

create or replace function notify_update_${table}() returns trigger as $$

  begin

    insert into ${table}_log values (NEW.${idField}, 'update');

    return NEW;

  end;

$$

language plpgsql volatile;

create or replace function notify_delete_${table}() returns trigger as $$

  begin

    insert into ${table}_log values (OLD.${idField}, 'delete');

    return NEW;

  end;

$$

language plpgsql volatile;

create trigger notify_insert_${table} 

	after insert on ${table} 

	for each row execute procedure notify_insert_${table}();

create trigger notify_update_${table} 

	after update on ${table}

	for each row execute procedure notify_update_${table}();

create trigger notify_delete_${table} 

	after delete on ${table} 

	for each row execute procedure notify_delete_${table}();

DROP TRIGGER IF EXISTS notify_insert_${table} ON ${table};

DROP TRIGGER IF EXISTS notify_update_${table} ON ${table};

DROP TRIGGER IF EXISTS notify_delete_${table} ON ${table};

DROP FUNCTION IF EXISTS notify_insert_${table}();

DROP FUNCTION IF EXISTS notify_update_${table}();

DROP FUNCTION IF EXISTS notify_delete_${table}();

DROP TABLE IF EXISTS ${table}_log;