CREATE TABLE IF NOT EXISTS sensor_data ( | |
time timestamptz NOT NULL, | |
device_id text NOT NULL, | |
temperature double PRECISION NOT NULL, | |
humidity double PRECISION NOT NULL, | |
lpg double PRECISION NOT NULL, | |
co double PRECISION NOT NULL, | |
smoke double PRECISION NOT NULL, | |
light boolean NOT NULL, | |
motion boolean NOT NULL | |
); | |
SELECT create_hypertable('sensor_data', 'time'); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment