How to remove the DEFAULT value of a table column in PostgreSQL

No Comments

Execute the following command

ALTER TABLE your_table ALTER COLUMN your_column DROP DEFAULT;

Replace your_table with the table and your_column with the column name where you wish to remove the default value

The above command is the same as setting the DEFAULT to NULL

Image Credits: Photo by Isis França on Unsplash.

Last Updated On April 07, 2018

Related Articles

No results found

Leave a Reply

avatar
  Subscribe  
Notify of
Menu
Copy link