How do I change column default value in PostgreSQL ?

How do I change column default value in PostgreSQL ?

Asked on January 8, 2019 in PostgreSQL.
Add Comment


  • 1 Answer(s)

    This query  can used to remove the default value constraint,

    ALTER TABLE <table> ALTER COLUMN <column> DROP DEFAULT;
    
    
    Answered on January 8, 2019.
    Add Comment


  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.