访问物化视图
最近更新时间: 2025-02-18 16:02:00
postgres=# select * from t_range_mv;
f1 | f2
----+------------
1 | 2017-09-27
2 | 2017-09-27
2 | 2017-09-27
1 | 2017-09-27
3 | 2017-09-27
(5 rows)
postgres=# insert into t_range(f1,f3) values(5,10);
INSERT 0 1
postgres=# select * from t_range;
f1 | f2 | f3 | f4
----+----------------------------+-----+----
1 | 2017-09-27 23:17:39.674318 | 1 |
2 | 2017-09-27 23:17:39.674318 | 50 |
5 | 2017-09-27 23:50:51.576173 | 10 |
2 | 2017-09-27 23:17:39.674318 | 110 |
1 | 2017-09-27 23:39:45.841093 | 151 |
3 | 2017-09-27 23:17:39.674318 | 100 |
(6 rows)