PostgreSQL
Basics
How to Insert in PostgreSQL How to Update in PostgreSQL How to Delete in PostgreSQL
Database Management
How to Create a Table in PostgreSQL How to Drop a Table in PostgreSQL How to Rename a Table in PostgreSQL How to Truncate a Table in PostgreSQL How to Duplicate a Table in PostgreSQL How to Add a Column in PostgreSQL How to Drop a Column in PostgreSQL How to Rename a Column in PostgreSQL How to Add a Default Value to a Column in PostgreSQL How to Remove a Default Value From a Column in PostgreSQL How to Add a Not Null Constraint in PostgreSQL How to Remove a Not Null Constraint in PostgreSQL How to Create an Index in PostgreSQL How to Drop an Index in PostgreSQL How to Create a View in PostgreSQL How to Drop a View in PostgreSQL How to Alter Sequence in PostgreSQL
Dates and Times
How to Query Date and Time in PostgreSQL How to Group by Time in PostgreSQL How to Round Timestamps in PostgreSQL How to Convert UTC to Local Time Zone in PostgreSQL
Analysis
How to Calculate Percentiles in PostgreSQL How to Get the First Row per Group in PostgreSQL How to Use generate_series to Avoid Gaps In Data in PostgreSQL How to Do Type Casting in PostgreSQL How to Write a Common Table Expression in PostgreSQL How to Import a CSV in PostgreSQL How to Compare Two Values When One Is Null in PostgreSQL How to Use Coalesce in PostgreSQL How to Write a Case Statement in PostgreSQL How to Query a JSON Column in PostgreSQL How to Use Filter to Have Multiple Counts in PostgreSQL How to Calculate Cumulative Sum/Running Total in PostgreSQL
Learn SQL /
PostgreSQL
/
How to Remove a Default Value From a Column in PostgreSQL

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;
How to Add a Default Value to a Column in PostgreSQL
How to Add a Not Null Constraint in PostgreSQL