4 time timestamp without time zone default now(),
9 CREATE OR REPLACE FUNCTION json_tele_fn()
13 NEW := jsonb_populate_record(NEW, NEW.json); -- or hstore alternative
14 NEW.time = NEW.json->'Time';
17 $func$ LANGUAGE plpgsql;
19 CREATE TRIGGER json_tele_trigger
20 BEFORE INSERT OR UPDATE ON tele FOR EACH ROW
21 EXECUTE PROCEDURE json_tele_fn();