3 time timestamp without time zone default now(),
11 CREATE OR REPLACE FUNCTION json_fn()
15 NEW := jsonb_populate_record(NEW, NEW.json); -- or hstore alternative
18 $func$ LANGUAGE plpgsql;
20 CREATE TRIGGER json_trigger
21 BEFORE INSERT OR UPDATE ON eg5120 FOR EACH ROW
22 EXECUTE PROCEDURE json_fn();