CODEWITHSUNDEEP
pythondjangopostgresqldjango-modelsdjango-orm
rangarajan
rangarajan

Reputation: 191

How to create tables in a different schema in django?

I'm using postgresql database in my django project.

I have multiple apps in my projects.

users/
    UserProfile model
myapp/
    CustomModel model

Now I need UserProfile table should be created in public schema And CustomModel table needs to be created in a separate schema called myapp

How to implement this and Do I need to change anything in the queries or migration command in future after implementing this?

Upvotes: 1

Views: 4399

Answers (2)

Aliasghar Safari
Aliasghar Safari

Reputation: 11

FOr Sql Server Use

class User(models.Model)
class Meta:
    db_table = '[schema].[tablename]'

Upvotes: 1

Nitish
Nitish

Reputation: 462

Just use a meta information:

class User(models.Model)
    class Meta:
        db_table = 'schema"."tablename'

I've been using it from some time and found not problem so far.

More info: This will replace table name in all your database queries with db_table. So any query will SELECT * FROM "tablename" will be converted to SELECT * FROM "geo"."tablename". Its just a neat trick, hopefully Django gives this option natively in future.

Upvotes: 9

Related Questions