Refreshing a PostgreSQL materialised view and returning the rowcount
1
vote
1
answer
43
views
Immediately after refreshing a materialised view in Postgres I'd like to know how many rows are in it.
Currently I do this by running a 2nd SQL command (
SELECT count(*) FROM
...)
Is there a more efficient way of doing this? Can the REFRESH command be persuaded to return the rowcount?
Asked by ConanTheGerbil
(1303 rep)
Apr 12, 2025, 09:12 AM
Last activity: Apr 13, 2025, 12:07 PM
Last activity: Apr 13, 2025, 12:07 PM