Introducing PopSQL + dbt. The first SQL editor with built-in dbt support.Read more →

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;

Ready for a modern SQL editor?