Difference between revisions of "Create hypertable"
Jump to navigation
Jump to search
(→Errors) |
|||
| (3 intermediate revisions by 2 users not shown) | |||
| 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 == | ||
| + | * <code>[[ERROR]] #42883 function create_hypertable(unknown, unknown) does not exist</code> | ||
| + | == See also == | ||
* {{Timescale}} | * {{Timescale}} | ||
| + | |||
| + | [[Category:Timescale]] | ||
Latest revision as of 12:53, 1 March 2024
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:
