manage.py sql command for django models - Django

Question

just wondering... but is it possible to generate SQL commands for django's models?

e.g. the session model

python manage.py sql django

Any ideas?

Martin v. Löwis · Accepted Answer · 2010-11-22 14:47:35Z

8

You need to mention the name of the specific app that comes with django, such as

 python manage.py sql auth
 python manage.py sql admin

I find it a bit clumsy that you can't give fully-qualified names (such as django.contrib.auth), but using just the last part of the name seems to work fine.

answered Nov 22, 2010 at 14:47

Martin v. Löwis

128k20 gold badges205 silver badges238 bronze badges

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

Comments

Joe Jasinski · Accepted Answer · 2017-01-06 16:57:00Z

2

This is no longer possible with django migrations (django>=1.7). The sql management command is no longer available.

Though it operates slightly differently, the sqlmigrate management command can be used to find the sql commands for individual migrations.

./manage.py sqlmigrate auth  0001
./manage.py sqlmigrate auth  0002
...

answered Jan 6, 2017 at 16:57

Joe Jasinski

10.9k18 gold badges77 silver badges112 bronze badges

Collectives™ on Stack Overflow

manage.py sql command for django models - Django

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related