Couple Postgres View Questions - Mailing list pgsql-general

From Brian Maguire
Subject Couple Postgres View Questions
Date
Msg-id 2F2E24372F10744588A27DEECC85FE040103E72C@vt-pe2550-001.vantage.vantage.com
Whole thread Raw
List pgsql-general
I have a couple questions about Postgres and Views.

I am curious about what Postgres actually does in regards to views and
the internal steps that it takes.

Are these the steps that it takes for each query that includes a view?
1. Dynamically Creates a Temp table with the view's select statement.
2. Executes the sql command against the view
3. Postgres destroys the temp table.


I understand that Postgres is not SQL 92 compliant with views because it
does not support updatable views.  Are there plans ever to support
updatable views?


Thanks,
Brian

pgsql-general by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: Postgresql "FIFO" Tables, How-To ?
Next
From: "Kirill Ponazdyr"
Date:
Subject: Re: Postgresql "FIFO" Tables, How-To ?