How to cast types in postgre?

Question

PostgreSQL

I made a request that displays all columns with the tinyint type. Displayed a list of columns that can cause problems during the exchange, because. they are most likely in the Postgre database as boolean too. those. they are of type tinyint.

How to bring all types with a script? In the boolean.

Answer 1

There is no tinyint data type in postgresql.
It is impossible to get from the bool number, so the default cast is not implied. If you are interested in the rule 0 - false, everything else is true - then write in the data migration (field != 0). The result will be bool.