No, in some specific cases I can not create another db, because of restrictive permissions of client systems.
In worst case I will have to search and replace prefixes in the files. I thought that maybe there is an easier solution that I did not know of. Thanks for all the suggestions! Regards, Chris On Monday, November 26, 2012 7:38:31 PM UTC+1, Richard wrote: > > You can't create more db? > > If you use postgres database, you could have look at schema, they serves > that purpose, and I am not sure but I think I read that web2py now support > postgres schemas. > > Richard > > On Fri, Nov 23, 2012 at 3:09 PM, Chr_M <chr....@gmail.com <javascript:>>wrote: > >> That, but even the same app using different tables in the same db (but >> for different cliënts)... >> >> Regards, Chris >> >> >> >> On Friday, November 23, 2012 7:00:28 PM UTC+1, Richard wrote: >> >>> Why exactly you change prefix? Installing differents apps dbs in the >>> same db? >>> >>> Richard >>> >>> >>> On Fri, Nov 23, 2012 at 10:57 AM, Chr_M <chr....@gmail.com> wrote: >>> >>>> Hi, >>>> >>>> I am new to web2py and am migrating an application to web2py. All the >>>> tables have a prefix that changes for the different deployments of the >>>> application. Is there a way in web2py to have a prefix for all the tables >>>> in the database that I can change easely for different deployments? >>>> >>>> At this time I use a >>>> >>>> PREFIX = 'prefix_' >>>> >>>> constant and define tables with >>>> >>>> db.define_table(PREFIX + 'table_name', etc... >>>> >>>> but this is becoming a bit complicated when defining requirements etc. >>>> Maybe there is an easier solution? >>>> >>>> Thanks in advance. >>>> >>>> Regards, Chris >>>> >>>> -- >>>> >>>> >>>> >>>> >>> >>> -- >> >> >> >> > > --
