[Babase] fecal views
Karl O. Pinc
kop at meme.com
Mon Apr 23 11:26:04 EDT 2007
On 04/20/2007 12:51:29 PM, kfenn wrote:
> Hi Karl,
>
> When you next do an update the incorporates the fecal tables into the
> babase db, can we add a view for the fecal tables as well? Laurence
> says she joins parts of the two fecal tables to start most of her
> queries so a view of this would be helpful.
Until then, you're the owner of the schema so you can make a view.
You just write the SELECT statement you want and put
CREATE VIEW yourviewname AS
in front of the SELECT. See:
http://www.postgresql.org/docs/8.1/static/sql-createview.html
After you do that you also have to do the GRANT stuff, just
as if the new view was a new table, so people have permission
to use the view.
I'm sure there's also a way to do it in PPA but I don't know
what it is.
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
More information about the Babase
mailing list