Adapt materialized view from oracle db to postgres

Question

I created materialized view in oracle and I used refresh force on demand option. Is there any possibility to adapt it to postgresql?

user330315 · Accepted Answer · 2015-08-03 09:48:32Z

1

refresh force on demand is actually the only option that Postgres currently supports (there is no refresh next or refresh fast in Postgres)

So there is nothing you need to do, just create the mview:

create materialized view mv_stuff
as
select *
from foobar;

answered Aug 3, 2015 at 9:48

user330315

Sign up to request clarification or add additional context in comments.

2 Comments

adolzi Over a year ago

Ok, but what if I added START WITH extra?

user330315 Over a year ago

Changing the scope of the question after getting an answer is not the way this site works. You should state all relevant information in your quesiton. But start with is not supported either. Please read the manual, it's all explained there: postgresql.org/docs/current/static/…

Collectives™ on Stack Overflow

Adapt materialized view from oracle db to postgres

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related