In this blog post, we'll be focusing on PostgreSQL data types in YugabyteDB, exploring the various categories of SQL data types and testing their compatibility with YugabyteDB. We start by examining the boolean data type, followed by character and string data types such as char, varchar, and text. Then, we delve into integer data types including smallint, int, and serial. Next, we investigate floating-point number data types like float(n), real, and numeric(p,s). Temporal data types allow us to store date and/or time data, while array data types provide a companion type for every data type in PostgreSQL. We also explore JSON data types, including plain JSON and JSONB, as well as UUID data types which guarantee better uniqueness than SERIAL. Additionally, we cover special data types such as box, line, point, and inet, and user-defined data types created using CREATE DOMAIN and CREATE TYPE commands. By comparing YugabyteDB to other databases like CockroachDB, Google Cloud Spanner, and MongoDB, developers can gain a deeper understanding of the capabilities and limitations of each database system.