TimescaleDB Example

Create Database

CREATE DATABASE vicroads;
CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;

Create Table

DROP TABLE detector;
CREATE TABLE detector (
        "id" INTEGER PRIMARY KEY,
        "name" TEXT,
        "link_key" TEXT,
        "description" TEXT,
        "x" NUMERIC,
        "y" NUMERIC
);