Postgres/TimescaleDB: Difference between revisions
< Postgres
Created page with "== Setup == <pre> CREATE TABLE sensor_data ( time TIMESTAMPTZ NOT NULL, location TEXT, value DOUBLE PRECISION ); </pre> Category:Linux/Services Category:Linux" |
mNo edit summary |
||
| Line 7: | Line 7: | ||
); | ); | ||
</pre> | </pre> | ||
<pre> | |||
SELECT create_hypertable('sensor_data', 'time'); | |||
</pre> | |||
[[Category:Linux/Services]] | [[Category:Linux/Services]] | ||
[[Category:Linux]] | [[Category:Linux]] | ||
Revision as of 13:01, 28 September 2024
Setup
CREATE TABLE sensor_data (
time TIMESTAMPTZ NOT NULL,
location TEXT,
value DOUBLE PRECISION
);
SELECT create_hypertable('sensor_data', 'time');