"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