Alter a hypertable

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

  1. ALTER TABLE conditions
  2. 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.