Skip to content

Postgres SQL TABLE sensors

Romain Tourte edited this page Oct 2, 2019 · 3 revisions

-- Table: public.sensors

-- DROP TABLE public.sensors;

CREATE TABLE public.sensors ( "mqttUser" "char"[], "phSensor" double precision, "temperatureSensor" double precision, "doSensor" double precision, "ecSensor" double precision, "tdsSensor" double precision, "orpSensor" double precision, "user" character varying COLLATE pg_catalog."default", longitude double precision, latitude double precision, "precision" double precision, speed double precision, "time" time without time zone, date date ) WITH ( OIDS = FALSE ) TABLESPACE pg_default;

ALTER TABLE public.sensors OWNER to postgres;

Clone this wiki locally