I believe we are using case insensitive collation, but I we weren't we'd be 
screwed...as would any PostgreSQL user with forced capitals in the table names. 
What is the web2py convention for naming tables and fields anyways?

On Feb 25, 2011, at 11:42 AM, Vasile Ermicioi wrote:

> http://weblogs.sqlteam.com/mladenp/archive/2006/12/07/44176.aspx
> 
> if you use a case insensitive collation you can use lower case, but without 
> underscore
> 
> db.define_table('globalsettings', Field('settingname'))
> 
> rows = db(db.globalsettings).select()

Reply via email to