postgresql
  1. postgresql-boolean
PreviousNext

Boolean - (PostgreSQL Data Types)

Boolean is a data type in PostgreSQL that represents logical truth values. It is a simple data type that can have two values: TRUE or FALSE. In this tutorial, we will discuss the syntax, example, output, explanation, use, important points, and summary of the Boolean data type in PostgreSQL.

Syntax

The syntax for defining a Boolean data type in PostgreSQL is as follows:

column_name BOOLEAN

Example

Let's take a look at an example of creating a table with a Boolean data type:

CREATE TABLE test_table (
    id SERIAL,
    is_active BOOLEAN NOT NULL DEFAULT FALSE,
    PRIMARY KEY (id)
);

In this example, we created a table named "test_table" with two columns. The first column is an auto-incrementing "id" column, and the second column is a Boolean column named "is_active". The "NOT NULL" constraint specifies that a value must be provided for this column when inserting a row. The "DEFAULT FALSE" constraint sets the default value for this column to "FALSE".

Output

If you execute the above CREATE TABLE statement, you will see the following output:

CREATE TABLE

Explanation

The Boolean data type in PostgreSQL can have two values: TRUE or FALSE. It can be used to represent simple values such as "yes" or "no", "on" or "off", or "true" or "false".

In the example above, we created a table with a Boolean column named "is_active". This column will store either TRUE or FALSE values, and a value must be provided for this column when inserting a row.

Use

The Boolean data type in PostgreSQL is useful in situations where you need to represent logical truth values. Some common use cases include:

  • Storing "yes" or "no" values for a checkbox or toggle switch.
  • Storing "on" or "off" values for a feature toggle.
  • Storing "true" or "false" values for a boolean flag.

Important Points

  • The Boolean data type in PostgreSQL is represented as a single byte.
  • The Boolean data type in PostgreSQL has the following aliases: BOOL and BOOLEAN.
  • The TRUE value is not equal to 1, and the FALSE value is not equal to 0 in PostgreSQL.

Summary

In this tutorial, we discussed the Boolean data type in PostgreSQL. We covered the syntax, example, output, explanation, use, and important points of using Boolean data type in PostgreSQL. With this knowledge, you can now use the Boolean data type to represent logical truth values in your PostgreSQL database.

VarcharInteger
Published on: