0

I have a table with sensor data and I'd like to change the type for a column, is there a quick way to do this?

funnymay
  • 341
  • 1
  • 6

1 Answers1

1

This is a planned feature and there is an issue tracking the status.

You can create a new table and cast column values to another type if this is a suitable workaround:

CREATE TABLE new_table AS(SELECT * FROM existing_table), 
cast(long_value AS INT);

The behavior of casts will apply.

Brian Smith
  • 1,222
  • 7
  • 17