Changing the column header of a table in a postgres database

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., Sep 18 '20 at 02:27

score 2 · Accepted Answer · answered Sep 18 '20 at 02:30

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 '20 at 02:30

1 Answers1