Add column with default null value

Question

I use rails with postgreSQL, I want to add a new column with a default null value, do I have to specify the default null value?

add_column :posts, :string, default: null

posts is table name, string is datatype, then where did you miss column name ? Also you do not need to set default to null for string as its default value is null — ray
– ray, Commented Feb 4, 2019 at 12:02

P. Boro · Accepted Answer · 2019-02-04 11:51:07Z

5

You don't need to specify it. When you add new column to table without default value all the values will be null. Also: note that in ruby the equivalent of psql Null value is nil.

answered Feb 4, 2019 at 11:51

P. Boro

7963 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Add column with default null value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related