Ok, found the answer ... https://groups.google.com/forum/#!topic/web2py/DCsnCkQnIoA
On Mon, Oct 29, 2018 at 12:27 PM Ben Duncan <linux...@gmail.com> wrote: > I'm thinking it should be no different than defining a table, since these > are all external / predefined tables. > The difference is that Postgres handles the sql and I'm guessing with DAL, > it's just data returned. > > Ben Duncan > > On Mon, Oct 29, 2018 at 12:14 PM 黄祥 <steve.van.chris...@gmail.com> wrote: > >> had you try DAL's execute sql ? >> ref: >> >> http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#executesql >> >> best regards, >> stifan >> >> -- >> Resources: >> - http://web2py.com >> - http://web2py.com/book (Documentation) >> - http://github.com/web2py/web2py (Source code) >> - https://code.google.com/p/web2py/issues/list (Report Issues) >> --- >> You received this message because you are subscribed to the Google Groups >> "web2py-users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to web2py+unsubscr...@googlegroups.com. >> For more options, visit https://groups.google.com/d/optout. >> > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.