you'd use a DDL() for that:

from sqlalchemy import event, DDL

event.listen(mymedata, "after_create", DDL("CREATE INDEX 
users_lower_username_idx ON users (lower(username))"))

http://docs.sqlalchemy.org/en/latest/core/schema.html#custom-ddl


On Apr 3, 2012, at 12:13 PM, David Bowser wrote:

> With postgres in raw sql I can do create an index like: "CREATE INDEX 
> users_lower_username_idx ON users (lower(username));" 
> 
> How would I do this in sqlalchemy using a declarative model?
> 
> -- 
> You received this message because you are subscribed to the Google Groups 
> "sqlalchemy" group.
> To post to this group, send email to sqlalchemy@googlegroups.com.
> To unsubscribe from this group, send email to 
> sqlalchemy+unsubscr...@googlegroups.com.
> For more options, visit this group at 
> http://groups.google.com/group/sqlalchemy?hl=en.
> 

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.

Reply via email to