How to drop App table with Django and Postgres

Question

I'm trying to drop a single table from my App's database in a Django project. When I enter the database shell using manage.py dbshell, I try to execute DROP TABLE mytable; and get ERROR: table "mytable" does not exist I think the cause of this stems from the database thinking I'm in my project directory instead of my app directory but I don't know how to change that.

This is what the shell looks like after I type ./manage.py dbshell:

myproject=# DROP TABLE mytable; ERROR: table "mytable" does not exist

I think instead of myproject=# it should say something like myapp=# or myproject/myapp=# but I do not know how to accomplish this.

remove corresponding models from models.py and do migration — JPG
– JPG, Commented Apr 4, 2018 at 7:42
Removing the model from model.py will force me to also remove any (or most) references to that model in my code before I can see if it works. It'll be tedious but I may do that as a last resort. — default123
– default123, Commented Apr 4, 2018 at 8:04

inmate37 · Accepted Answer · 2018-04-04 07:43:05Z

23

After accessing your local db via: sudo -i -u postgres

Or python manage.py dbshell

Try typing \l to see what databases do you actually have

Then \dt to see a list of relations

And then DROP TABLE some_table;

answered Apr 4, 2018 at 7:43

inmate37

1,2385 gold badges19 silver badges33 bronze badges

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

6 Comments

default123 Over a year ago

Thank you for your response. I after typing in those commands, the only relevant database that shows up is in fact the MyProject database. Am I only able to delete this?

inmate37 Over a year ago

Well there must be several databases including the database of your django project, others are a standard postgresql databases, you might delete them as well, but there is no point in doing so

inmate37 Over a year ago

Let me know if there are some other issues

default123 Over a year ago

You were correct! I was looking at the wrong layout. At the bottom of the \dt output was the myapp_mytable name that I needed to type in to delete it. I was simply typing the incorrect name. Thank you very much for your help! I was stuck on this for awhile.

elias sharafi Over a year ago

thanks :) DROP TABLE public."some_table"; worked for me.

|

Collectives™ on Stack Overflow

How to drop App table with Django and Postgres

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related