Yep, views and store procedures have to be defined in migrations sadly. sndev psql can help you inspect stuff pretty well though.
stackernews=# \dv
List of relations
Schema | Name | Type | Owner
--------+-----------------------------+------+-------
public | all_days | view | sn
public | all_months | view | sn
public | days | view | sn
public | hot_score_constants | view | sn
public | last_24_hours | view | sn
public | today | view | sn
public | zap_rank_constants | view | sn
public | zap_rank_personal_constants | view | sn
(8 rows)
stackernews=# \dm
List of relations
Schema | Name | Type | Owner
--------+-----------------------------+-------------------+-------
public | all_days | view | sn
public | all_months | view | sn
public | days | view | sn
public | hot_score_constants | view | sn
public | hot_score_view | materialized view | sn
public | item_growth_days | materialized view | sn
public | item_growth_hours | materialized view | sn
public | item_growth_months | materialized view | sn
public | last_24_hours | view | sn
public | reg_growth_days | materialized view | sn
public | reg_growth_hours | materialized view | sn
public | reg_growth_months | materialized view | sn
public | rewards_days | materialized view | sn
public | rewards_today | materialized view | sn
public | sat_rank_tender_view | materialized view | sn
public | sat_rank_wwm_view | materialized view | sn
public | spender_growth_days | materialized view | sn
public | spender_growth_hours | materialized view | sn
public | spender_growth_months | materialized view | sn
public | spending_growth_days | materialized view | sn
public | spending_growth_hours | materialized view | sn
public | spending_growth_months | materialized view | sn
public | stackers_growth_days | materialized view | sn
public | stackers_growth_hours | materialized view | sn
public | stackers_growth_months | materialized view | sn
public | stacking_growth_days | materialized view | sn
public | stacking_growth_hours | materialized view | sn
public | stacking_growth_months | materialized view | sn
public | sub_stats_days | materialized view | sn
public | sub_stats_hours | materialized view | sn
public | sub_stats_months | materialized view | sn
public | today | view | sn
public | user_stats_days | materialized view | sn
public | user_stats_hours | materialized view | sn
public | user_stats_months | materialized view | sn
public | user_values_days | materialized view | sn
public | user_values_today | materialized view | sn
public | zap_rank_constants | view | sn
public | zap_rank_personal_constants | view | sn
public | zap_rank_personal_view | materialized view | sn
public | zap_rank_tender_view | materialized view | sn
public | zap_rank_wwm_view | materialized view | sn
(42 rows)
Then, I'll usually just search in primsa for them. I'll be going through and deleting some of these unused views soon. I'll create a doc for them all while I'm doing that.
sndev psqlcan help you inspect stuff pretty well though.primsafor them. I'll be going through and deleting some of these unused views soon. I'll create a doc for them all while I'm doing that.