create hypertable

From wikieduonline
Jump to navigation Jump to search

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

Official example[edit]

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[edit]

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

See also[edit]

Advertising: