Re: [HACKERS] create rule changes table to view ?

Thus spake Peter Eisentraut
> I don't know what other people use their views for but I use them to store
> complicated queries. So, in essence it would suffice to store the text of
> the query with a view rather than faking tables for it, thus confusing all
> sorts of utility programs.
> 
> Then again, I'd be interested to know what to developers' idea of normal
> usage of a view is.

I use it for access control.  Remember, in PostgreSQL we can grant and
revoke access to tables independent of the table it is a view of.  I use
it to allow wider access to a subset of the fields in a table.

-- 
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 424 2871     (DoD#0082)    (eNTP)   |  what's for dinner.