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)