Changing the column header of a table in a postgres database [duplicate]

Question

I am trying to rename a column in my database.

I did

heroku pg:psql

ALTER TABLE discounts_discount RENAME COLUMN percentagediscountm TO percentagediscount

And that had no impact. I looked on a few sites and to the best of my knowledge, what I wrote above should work.

I tried making the change using make migrations and migrate but then got this error.

django.core.exceptions.FieldDoesNotExist: discounts.discount has no field named 'percentagediscountm'

I am really trying to avoid having to drop my database or rolling back Heroku to an earlier build.

Don't do manual changes to your database structure if you want to keep the migrations in sync. — Klaus D.
– Klaus D., Commented Sep 18, 2020 at 2:27

Biplove Lamichhane · Accepted Answer · 2020-09-18 02:30:41Z

2

You can enter the same command with ; at the end. That should work:

ALTER TABLE discounts_discount RENAME COLUMN percentagediscountm TO percentagediscount;

You can see Here to get the detail knowledge on how it was not working.

answered Sep 18, 2020 at 2:30

4,1055 gold badges17 silver badges33 bronze badges

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

1 Answer 1