Versions:
Alter a hypertable
You can alter a hypertable, for example to add a column, by using a standard
ALTER TABLE command. This works for both regular and
distributed hypertables.
In the following example, the hypertable is named conditions and the new
column is named humidity:
ALTER TABLE conditions
ADD COLUMN humidity DOUBLE PRECISION NULL;note
Adding a column is efficient so long as you set its default value to NULL. If you set the default to a non-null value, it takes longer, because TimescaleDB needs to fill in this value for all existing rows of all existing chunks.
Found an issue on this page?
Report an issue!Keywords