create hypertable

From wikieduonline
Revision as of 09:39, 14 February 2023 by Brave (talk | contribs)
Jump to navigation Jump to search

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

Advertising: