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)