Select Page

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

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

Last Updated On April 07, 2018

Leave a reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.