Is this proper postgresql syntax to add a column to a table with a default value of false

ALTER TABLE users
ADD "priv_user" BIT
ALTER priv_user SET DEFAULT '0'

Thanks!

5 Answers
5

Leave a Reply

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