Is there any way to write a materialized view in PostgreSQL which refreshes it self automatically by specifying something while creating it?
As of now, it's not available, you can use the following command to refresh it whenever you make changes to the base tables: REFRESH MATERIALIZED VIEW MY_NAME