postgresql - add boolean column to table set default

Question

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

User · Answer

If you are using postgresql then you have to use column type BOOLEAN in lower case as boolean   ALTER TABLE users ADD  priv user  boolean DEFAULT false

User · Answer

In psql alter column query syntax like this   Alter table users add column priv user boolean default false     boolean value  true-false  save in DB like  t-f  value

User · Answer

If you want an actual boolean column   ALTER TABLE users ADD  priv user  boolean DEFAULT false

User · Answer

ALTER TABLE users   ADD COLUMN  priv user  BOOLEAN DEFAULT FALSE    you can also directly specify NOT NULL  ALTER TABLE users   ADD COLUMN  priv user  BOOLEAN NOT NULL DEFAULT FALSE    UPDATE  following is only true for versions before postgresql 11   As Craig mentioned on filled tables it is more efficient to split it into steps   ALTER TABLE users ADD COLUMN priv user BOOLEAN  UPDATE users SET priv user    f   ALTER TABLE users ALTER COLUMN priv user SET NOT NULL  ALTER TABLE users ALTER COLUMN priv user SET DEFAULT FALSE

User · Answer

Just for future reference  if you already have a boolean column and you just want to add a default do   ALTER TABLE users   ALTER COLUMN priv user SET DEFAULT false

[sql] postgresql - add boolean column to table set default

Examples related to sql

Examples related to postgresql