Get startedGet started for free

Boolean defaults

A BOOLEAN column defaulting to null is not always desired. In some situations, a default value of true might be preferred. Imagine a user management system built for a website. The default behavior is to authorize a newly registered user to access the website. This access remains available unless the user exhibits poor community behavior. Including an approved column on a user table in this database enables such a process. This column is true by default in this scenario.

This exercise is part of the course

Creating PostgreSQL Databases

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise