I am new to Postgres. Is there a way to update part of the data in a materialized view? I think this would be beneficial for my application compared to a traditional view, as several joins will be involved and it would be good to have a near instantaneous report on the data obtained.
My view would have columns similar to:
For example, I would like to update all lines that have a certain
User ID or
Account ID on demand.