[web2py] Re: Postgresql database schema

2011-05-31 Thread Mathew Grabau
You could always do the db.define_table calls specific to the tables that are in the schema: def define_schema1(): db.define_table("table1") # and so forth def define_schema1(): db.define_table("tablea") # and so forth # later on... (after changing the schema) if current_schema

Re: [web2py] Re: Postgresql database schema

2011-05-31 Thread Massimiliano
Sure... That is the way I'm follow... Fortunately I haven't tables with the same name... Ciao On Tue, May 31, 2011 at 3:50 AM, Mathew Grabau wrote: > You could always change the schema before executing the db commands: > > db.executesql("set search_path to 'schemaname,public';") > > If you coul

[web2py] Re: Postgresql database schema

2011-05-30 Thread Mathew Grabau
You could always change the schema before executing the db commands: db.executesql("set search_path to 'schemaname,public';") If you could determine the name of the schema first that would be feasible. On May 30, 5:14 am, Massimiliano wrote: > Hi all, > > I've a legacy enterprise application th