Re: Views... - Mailing list pgsql-general

From Richard Huxton
Subject Re: Views...
Date
Msg-id 3ABDE11C.94B4A6CB@archonet.com
Whole thread Raw
In response to Re: Views...  ("Brett W. McCoy" <bmccoy@chapelperilous.net>)
Responses RE: Views...  ("Christian Marschalek" <cm@chello.at>)
List pgsql-general
"Brett W. McCoy" wrote:
>
> Briefly, a view is a 'virtual' table -- you create a view with a select
> statement that can relate data between different tables or use a subset of
> data from a specific table.  You can think of them as a 'saved query'.
> Once you create a view, you can then query them just like a normal table.
> You cannot, as of yet, update views in PostgreSQL, they are read only.

Not by default, but you can of course define your own rules to allow updating.

- Richard Huxton

pgsql-general by date:

Previous
From: Lincoln Yeoh
Date:
Subject: Re: Select for insert possible?
Next
From: "Christian Marschalek"
Date:
Subject: RE: Views...