flask-sqlalchemy - PostgreSQL - Define specific schema for table?
When you define your model class use:
__table_args__ = {"schema":"schema_name"}
maybe it will save someone else some hunting.
For future references:
db = flask.ext.sqlalchemy.SQLAlchemy(app)
app.config['SQLALCHEMY_DATABASE_URI'] = 'your_default_schema_db_uri'
app.config['SQLALCHEMY_BINDS'] = {'other_schema': 'your_other_db_uri'}
class TableA(db.Model):
# This belongs to Default schema, it doesn't need specify __bind_key__
...
class TableB(db.Model):
# This belongs to other_schema
__bind_key__ = 'other_schema'
...