create a table and convert to hypertable.bash

# First enter a postgres command line 
sudo -u postgres psql

# In postgres command line create a standard table
CREATE TABLE conditions (
  time        TIMESTAMPTZ       NOT NULL,
  location    TEXT              NOT NULL,
  temperature DOUBLE PRECISION  NULL,
  humidity    DOUBLE PRECISION  NULL
);
/* CONVERT TABLE
 * TO HYPERTABLE */
 
 SELECT create_hypertable('conditions', 'time');
 
/* ADD SOME RANDOM
 * DATA */
 
INSERT INTO conditions(time, location, temperature, humidity) VALUES (NOW(), 'office', 70.0, 50.0);
  
\q

# \q is to exit postgresql command line