Alter a distributed hypertable

You can execute standard ALTER TABLE commands against the hypertable (PostgreSQL docs).

ALTER TABLE conditions
  ADD COLUMN humidity DOUBLE PRECISION NULL;

TimescaleDB will then automatically propagate these schema changes to the chunks that constitute this hypertable.

warning
Altering a table's schema is quite efficient provided that the default value for any additional column is set to NULL. If the default is set to a non-null value, TimescaleDB will need to fill in this value for all rows (of all chunks) belonging to this hypertable.

Found an issue on this page?

Report an issue!