Difference between revisions of "Create hypertable"
Jump to navigation
Jump to search
| Line 2: | Line 2: | ||
[[SELECT]] create_hypertable('conditions', 'time'); | [[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 | [[ERROR]] #42883 function create_hypertable(unknown, unknown) does not exist | ||
Revision as of 09:39, 14 February 2023
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:
