func-trigger-after-insert.sql

CREATE OR REPLACE FUNCTION log_table_after_insert() RETURNS trigger LANGUAGE plpgsql AS $$
DECLARE
    v_new json;
BEGIN
    v_new = rec_to_json(TG_TABLE_SCHEMA, TG_TABLE_NAME, hstore(NEW));

    INSERT INTO log_table (table_schema, table_name, operation, new_values)
        VALUES (TG_TABLE_SCHEMA, TG_TABLE_NAME, 'insert', v_new);

    RETURN NEW;
END
$$