[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