+drop view s_all;
+create view s_all as
+select time AT TIME ZONE 'UTC-2' as time,
+ addr,
+ (json->'sensor_type')::int as sensor_type,
+ (json->'sensor_name')::text as sensor_name,
+ (json->>'battery')::float as bettery,
+ (json->>'battery_percent')::float as battery_percent,
+ (json->'counter')::int as counter
+from eg5120
+;
+grant select on s_all to gread ;
+
-- 1 Temperature/Humidity
drop view s_1;
create view s_1 as