| From: | "D'Arcy" "J(dot)M(dot)" Cain <darcy(at)druid(dot)net> |
|---|---|
| To: | peter(at)pathwaynet(dot)com (Peter Eisentraut) |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] create rule changes table to view ? |
| Date: | 1999-07-13 12:58:17 |
| Message-ID: | m11428X-0000bFC@druid.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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(at){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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 1999-07-13 15:33:23 | Re: [HACKERS] PostgreSQL v6.5 - Tagged |
| Previous Message | The Hermit Hacker | 1999-07-13 12:23:15 | PostgreSQL v6.5 - Tagged |