This content has been marked as final.
Show 1 reply
-
1. Re: Materialized view on two tables having one to many relationship
rareddy Jul 18, 2016 10:16 AM (in response to dineshnasa)1 of 1 people found this helpfulYou need to create view "DeptEmployeeView" with something like following transformation
select d.id,d.name,string_agg(e.name, ',') from Dept d inner join Employee e on d.id = e.deptId group by d.id
Then mark this view as materialized
Ramesh..