Postgres Pro
Downloads
Home   >   mailing lists

Re: Why no CREATE TEMP MATERIALIZED VIEW ? - Mailing list pgsql-general

From Adam Brusselback
Subject Re: Why no CREATE TEMP MATERIALIZED VIEW ?
Date
Msg-id CAMjNa7dKJsGxK7Fq7QrsC5hL3OJ7rzpBxMpsXWHxT41aFPk1WA@mail.gmail.com
Whole thread Raw
In response to Re: Why no CREATE TEMP MATERIALIZED VIEW ?  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
Tree view
> 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.

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Why no CREATE TEMP MATERIALIZED VIEW ?
Next
From: Alex Williams
Date:
Subject: Re: Tablespace column value null on select * from pg_tables