Routines
pg.public
Routines
| Name | Kind | Arguments | Returns | Language | Comment |
|---|---|---|---|---|---|
| set_updated_at | function | trigger | plpgsql | ||
BEGIN RETURN NEW; END; | |||||
Materialized views
| Name | With data | Indexes | Comment |
|---|---|---|---|
| mv_daily_sales | yes | ix_mv_daily_sales_day | |
SELECT date_trunc('day', placed_at) AS day, sum(total) AS total FROM public."order" GROUP BY 1 | |||