1

Is there any way to write a materialized view in PostgreSQL which refreshes it self automatically by specifying something while creating it?

Erwin Brandstetter
  • 605,456
  • 145
  • 1,078
  • 1,228
Suvarna
  • 165
  • 1
  • 8

1 Answers1

2

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

Disha Shetty
  • 36
  • 3