drop table tele;
create table tele (
	_id serial,
	time timestamp without time zone default now(),
	topic text not null,
	json jsonb
);

CREATE OR REPLACE FUNCTION json_tele_fn()
  RETURNS TRIGGER AS
$func$
BEGIN
   NEW := jsonb_populate_record(NEW, NEW.json); -- or hstore alternative
   NEW.time = NEW.json->'Time';
   RETURN NEW;
END
$func$ LANGUAGE plpgsql;

CREATE TRIGGER json_tele_trigger
BEFORE INSERT OR UPDATE ON tele FOR EACH ROW
EXECUTE PROCEDURE json_tele_fn();


