postgres version 12 I have very simple update query, like this: update my_table set col = NULL where col IS NOT NULL;
my_table contains few million rows, col is indexed column Fastest way would be alter table, drop column and then add column again, but I can't do this just because on this column depends bunch of views and materialized views. No much hope, but still asking, Is there some another way to just reset column all values? ( with NULL in my case)
