Sqlalchemy create a database table manually

Question

Is there a way to create a table without using Base.metadata.create_all(). I'm looking for something like Mytable.create() which should create only its corresponding table.

The reason I want to do so is because i'm using Postgres schemas for a multi-tenant web app and I want to create the public tables(Useretc) separately and the user specific(each having a separate schema, ex. Blog,Post) tables when the user signs up. However all the definitions lie in the same file and it seems that create_all creates all the tables defined in the file.

van · Accepted Answer · 2014-04-06 07:55:17Z

3

Please read documentation Creating and Dropping Database Tables.

You can do user_table.create(engine), or if you are using declarative extension: User.__table__.create(engine).

answered Apr 6, 2014 at 7:55

van

77.5k13 gold badges174 silver badges179 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

van Over a year ago

And you were right, only we are able to access those tables for each model.

Collectives™ on Stack Overflow

Sqlalchemy create a database table manually

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related