How to Remove a Default Value From a Column in PostgreSQL
Assuming orders.total_cents had a default value, this will drop the default for future inserts.
alter table orders alter column total_cents drop default;
Finally, a unified workspace for your SQL development
Get more done, together, with PopSQL and PostgreSQL