How to pledge the last creation date of MATERIALIZED VIEW?

Question

PostgreSQL

Is there a way to pledge the creation time of the last REFRESH MATERIALIZED VIEW?
In simple words, is it possible to get some kind of flag that the request:
REFRESH MATERIALIZED VIEW regions_view;
fulfilled. Is it possible?

I plan to execute the request from the programming language. And you need to somehow get the status of the True type - they say that everything worked out

Answer 1

The question in the title and the question in the description are two completely different questions.
Like other commands, PQresultStatus answers the question whether the request was completed. You need to check with your connection library how to check the status of the command. In many cases, everything is simple - if the method returned control (and did not throw an exception) - the command is executed.

Answer 2

Add an mterialized_at::timestamp column to the view with the value now() . This way you will know the update date