creating a materialzed view from three tables
create materialized view resourceentityview as
select r.id,
b.basename,
rk.rkey AS key,
p.id AS persistablelocale,
r.value
from resourceentity r,
basename b,
resourcekey rk,
persistablelocale p
where r.resourcekey = rk.id and rk.basename = b.id and r.persistablelocale = p.id
order BY b.basename, p.id, rk.rkey
with data;
alter table resourceentityview owner to alice;