Re: Why no CREATE TEMP MATERIALIZED VIEW ?

From: Adam Brusselback <adambrusselback(at)gmail(dot)com>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Why no CREATE TEMP MATERIALIZED VIEW ?
Date: 2019-07-16 18:06:41
Message-ID: CAMjNa7dKJsGxK7Fq7QrsC5hL3OJ7rzpBxMpsXWHxT41aFPk1WA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> How different is a "*temp* materialized view" from a regular view?

If it existed, it would be useful for cases when you need to reference that
view in multiple queries in the same session. I've gotten around this by
just using temp tables.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alex Williams 2019-07-16 19:20:24 Re: Tablespace column value null on select * from pg_tables
Previous Message Ron 2019-07-16 17:57:55 Re: Why no CREATE TEMP MATERIALIZED VIEW ?