How to add a table in django app models from PostgreSQL?

Question

I have created a django project named Book Store. In my project I have one app named books.

I am using PostgreSQL DBMS. I have a database called books. In that database, I have a table named novel. How do I add this table in the models.py file inside books app?

I want to register this table under admin site. After successfully adding this table in the models.py file, I believe, I shall be able to register the table in the admin site by writing the following codes in the admin.py file under books app.

from django.contrib import admin
from . models import novel

admin.site.register(novel)

I also want to know that if my approach is correct or is there any better way available? As I am new to django, I don't know much about it.

I have read django-book but didn't find out my answer. There is an article about SQLite database though.

Peter Sobhi · Accepted Answer · 2018-02-21 10:54:14Z

11

The convention here is that you should create your models first then you can create database tables to bind with by migrations:

python manage.py makemigrations
python manage.py migrate

there is another way which you can make django automatically create models for you based on the already implemented database tables:

python manage.py inspectdb > models.py

https://docs.djangoproject.com/en/2.0/howto/legacy-databases/

edited Feb 21, 2018 at 10:54

answered Feb 17, 2018 at 1:32

Peter Sobhi

2,5502 gold badges24 silver badges28 bronze badges

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

2 Comments

Peter Sobhi Over a year ago

more about Django models: docs.djangoproject.com/en/2.0/topics/db/models

Rubel Hosen Over a year ago

Second one works but imports all the table in the app. First one doesn't work. I have create model as class novel(models.Model): and then run the first two command in shell.

Collectives™ on Stack Overflow

How to add a table in django app models from PostgreSQL?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related