PostgreSQL基础 boolean 布尔类型

CentOS 7.6.1810
postgresql 14.4

boolean 布尔类型

postgres=# create table table_tf(col_t boolean,col_f boolean);
CREATE TABLE
postgres=# \d table_tf 
              Table "public.table_tf"
 Column |  Type   | Collation | Nullable | Default 
--------+---------+-----------+----------+---------
 col_t  | boolean |           |          | 
 col_f  | boolean |           |          | 

postgres=# insert into table_tf values
postgres-# ('true','false'),
postgres-# ('t','f'),
postgres-# ('TRUE','FALSE'),
postgres-# ('yes','no'),
postgres-# ('y','n'),
postgres-# ('1','0'),
postgres-# ('on','off');
INSERT 0 7

postgres=# select * from table_tf;
 col_t | col_f 
-------+-------
 t     | f
 t     | f
 t     | f
 t     | f
 t     | f
 t     | f
 t     | f
(7 rows)

postgres=# insert into table_tf values(null, null);
INSERT 0 1
postgres=# select * from table_tf;
 col_t | col_f 
-------+-------
 t     | f
 t     | f
 t     | f
 t     | f
 t     | f
 t     | f
 t     | f
       | 
(8 rows)

学习资料

• postgresql
• download-postgresql
• docs-postgresql
• db-engines
• 墨天轮社区

欢迎各位同学一起来交流学习心得！