Is DEFAULT NULL and 'nullable value without default' completely the same?

12 votes

2 answers

18609 views

postgresql datatypes postgresql-9.6 default-value

                              ALTER TABLE test_table ADD COLUMN a DEFAULT NULL;
    
vs.
    
    ALTER TABLE test_table ADD COLUMN a;

Both columns will set NULL if column a is not specified.

As far as I know, if I add a column into a table with a default value in production database, it could lead to trouble rewriting all rows with default value.

Is DEFAULT NULL the same?

Asked by SangminKim (359 rep)

Oct 16, 2019, 09:09 AM
Last activity: Aug 25, 2023, 08:52 PM

Is DEFAULT NULL and 'nullable value without default' completely the same?

Related Questions