Create a relational table

In this section, you create a table called sensors which holds the ID, type, and location of your fictional sensors. Additionally, you create a hypertable called sensor_data which holds the measurements of those sensors. The measurements contain the time, sensor_id, temperature reading, and CPU percentage of the sensors.

1. Compose a string which contains the SQL statement to create a relational table. This example creates a table called sensors, with columns id, type and location:

2. Create a statement, execute the query you created in the previous step, and check that the table was created successfully: