create hypertable

SELECT create_hypertable('conditions', 'time');

Official example

CREATE TABLE conditions ( -- create a regular table
 time         TIMESTAMPTZ       NOT NULL,
 location     TEXT              NOT NULL,
 temperature  DOUBLE PRECISION  NULL
);

SELECT create_hypertable('conditions', 'time');	-- turn it into a hypertable

Errors

• ERROR #42883 function create_hypertable(unknown, unknown) does not exist

See also

• TimescaleDB, Installation, tsdb, Timescale Cloud: brew install timescaledb, timescaledb-tune, timescaledb_move.sh, create_hypertable, versions, Timescale Vector