This is an example of a simple master detail report.
| Schema: ere | ||
|---|---|---|
| Name | Type | Owner |
| report_report | view | elein |
| rr_appgroups | table | elein |
| rr_prompts | table | elein |
| rr_reports | table | elein |
| rr_rprompts | table | elein |
| rr_types | table | elein |
| Schema: pg_catalog | ||
| Name | Type | Owner |
| pg_aggregate | table | postgres |
| pg_am | table | postgres |
| pg_amop | table | postgres |
| pg_amproc | table | postgres |
| pg_attrdef | table | postgres |
| pg_attribute | table | postgres |
| pg_cast | table | postgres |
| pg_class | table | postgres |
| pg_constraint | table | postgres |
| pg_conversion | table | postgres |
| pg_database | table | postgres |
| pg_depend | table | postgres |
| pg_description | table | postgres |
| pg_group | table | postgres |
| pg_index | table | postgres |
| pg_indexes | view | postgres |
| pg_inherits | table | postgres |
| pg_language | table | postgres |
| pg_largeobject | table | postgres |
| pg_listener | table | postgres |
| pg_locks | view | postgres |
| pg_namespace | table | postgres |
| pg_opclass | table | postgres |
| pg_operator | table | postgres |
| pg_proc | table | postgres |
| pg_rewrite | table | postgres |
| pg_rules | view | postgres |
| pg_settings | view | postgres |
| pg_shadow | table | postgres |
| pg_stat_activity | view | postgres |
| pg_stat_all_indexes | view | postgres |
| pg_stat_all_tables | view | postgres |
| pg_stat_database | view | postgres |
| pg_stat_sys_indexes | view | postgres |
| pg_stat_sys_tables | view | postgres |
| pg_stat_user_indexes | view | postgres |
| pg_stat_user_tables | view | postgres |
| pg_statio_all_indexes | view | postgres |
| pg_statio_all_sequences | view | postgres |
| pg_statio_all_tables | view | postgres |
| pg_statio_sys_indexes | view | postgres |
| pg_statio_sys_sequences | view | postgres |
| pg_statio_sys_tables | view | postgres |
| pg_statio_user_indexes | view | postgres |
| pg_statio_user_sequences | view | postgres |
| pg_statio_user_tables | view | postgres |
| pg_statistic | table | postgres |
| pg_stats | view | postgres |
| pg_tables | view | postgres |
| pg_trigger | table | postgres |
| pg_type | table | postgres |
| pg_user | view | postgres |
| pg_views | view | postgres |
| Schema: rugby | ||
| Name | Type | Owner |
| areas | table | elein |
| events | table | elein |
| teams | table | elein |
| teams_v | view | elein |
| tmatches | table | elein |
| tmatches_matid_seq | sequence | elein |
| ttypes | table | elein |
| videos | table | elein |
| videos_vidid_seq | sequence | elein |