[Sqlalchemy-tickets] Issue #3207: SQLAlchemy, postgres and schema (zzzeek/sqlalchemy)

[charles p. <iss...@bi...>]

New issue 3207: SQLAlchemy, postgres and schema
https://bitbucket.org/zzzeek/sqlalchemy/issue/3207/sqlalchemy-postgres-and-schema

charles pierre:

Hi, 
I am trying to work to setup a multi-schema environnement with sqlalchemy and postgres but i am struggling for two reasons :
-It seems that you cannot change dynamically the schema (i did metadata.schema = 'new_schema' and looped over all tables to also do table.schema = 'new_schema' but it feels like a hack). Does the library have a function to do this properly ?
-Some object does not inherit the schema option from the table or metadata. An example would be the postgresql enum type. How do you control in which schema the type gets created ? 

Responsible: zzzeek