postgres=# create table test_1(c1 bool,c2 int);

CREATE TABLE

postgres=# \d+ test_1;

                                         Table "public.test_1"

 Column |  Type   | Collation | Nullable | Default | Storage | Compression | 
Stats target | Description 

--------+---------+-----------+----------+---------+---------+-------------+--------------+-------------

 c1     | boolean |           |          |         | plain   |             |    
          | 

 c2     | integer |           |          |         | plain   |             |    
          | 

Access method: heap




postgres=# 



in the create table statement ,there is bool data type,
in the \d+ test_1, there is boolean data type,
PostgreSQL use format_type function to convert bool to boolean.


in other words,  bool datatype  is equal to boolean datatype,
 but  the documents(https://www.postgresql.org/docs/15/datatype-boolean.html ) 
there is no description about " bool dataype  is equal to boolean datatype ”

Reply via email to