Using the boolean type : Boolean « Data Type « PostgreSQL

1. PostgreSQL
2. Data Type
3. Boolean

Using the boolean type

postgres=#
postgres=#
postgres=# -- Using the boolean type
postgres=#
postgres=# CREATE TABLE test1 (a boolean, b text);
CREATE TABLE
postgres=# INSERT INTO test1 VALUES (TRUE, 'sic est');
INSERT 0 1
postgres=# INSERT INTO test1 VALUES (FALSE, 'non est');
INSERT 0 1
postgres=#
postgres=# SELECT * FROM test1;
 a |    b
---+---------
 t | sic est
 f | non est
(2 rows)

postgres=#
postgres=# SELECT * FROM test1 WHERE a;
 a |    b
---+---------
 t | sic est
(1 row)

postgres=#
postgres=# drop table test1;
DROP TABLE
postgres=#
           
       

Related examples in the same category