Support PostgreSQL materialized view.

[zKoz210]

Lacks materialized view support for PostgreSQL. An example of a table in a database:

Result:

[bastien-phi]

Can you create a new laravel project with this issue ? I would be easier for me to fix this

[zKoz210]

I'm pretty busy creating a new project. if I give you an example of SQL table creation, can you test it?

create table public.purchases (
    id integer,
    name varchar(255),
    amount integer
);

insert into public.purchases (id, name, amount) VALUES (1, 'Test1', 250);
insert into public.purchases (id, name, amount) VALUES (2, 'Test2', 3000);
insert into public.purchases (id, name, amount) VALUES (2, 'Test3', 5000);

create materialized view shop_statistics as
    select sum(amount) from public.purchases as sum_all_purchases;

refresh materialized view shop_statistics;

f you create a ShopStatistics model, no documentation is generated for this column/columns

[zKoz210]

doctrine/dbal#5821