1

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

Improve this question
1
  • 1
    No, that's currently not possible. Commented Jun 25, 2021 at 5:19

1 Answer 1

Reset to default
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

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.