ALTER TABLE users
ADD COLUMN "priv_user" BOOLEAN DEFAULT FALSE;
PostgreSQL supports a single Boolean data type: BOOLEAN that can have three values: true , false and NULL . PostgreSQL uses one byte for storing a boolean value in the database. The BOOLEAN can be abbreviated as BOOL .