dbeaver / dbeaver

Free universal database tool and SQL client
https://dbeaver.io
Apache License 2.0
40.68k stars 3.51k forks source link

A GUI button for refreshing materialized view in postgresql #34950

Open DavidHJong opened 4 months ago

DavidHJong commented 4 months ago

Is your feature request related to a problem? Please describe. I can't find a button to refresh materialized view in postgresql database. The context menu contains a "refresh" button but that doesn't work.

Describe the solution you'd like Add an option in the context menu, toolbar or top menu dedicated for updating the materialized view.

Additional context Dbeaver 24.0.2 Windows 10

LonwoLonwo commented 4 months ago

Hello @DavidHJong

Please check the Tools section in the navigator menu. Because it is not the same operation like to refresh an ordinary view or table.

image

DavidHJong commented 4 months ago

Thank you @LonwoLonwo! That works.

A side question, is there a way to always check the with data option?

arhayka commented 4 months ago

It seems that the Refresh Materialized View option is not easy to find. We discussed this issue with the team and decided that we could move this option to the first level, after the Filter.

Screenshot 2024-07-31 at 13 09 34