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 grabau@gmail.com wrote: You could always change the schema before executing the db commands: db.executesql(set search_path to 'schemaname,public';)

[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 ==

[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 mbelle...@gmail.com wrote: Hi all, I've a legacy enterprise