types

Jul 21, 2023

How to get the JSON field types in MySQL

To get the type of a JSON item in MySQL you need to use the JSON_TYPE function.

Jan 6, 2023

How to get the JSON field types in PostgreSQL®?

PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use the function json_typeof (jsonb_typeof for JSONB) to extract the fields type.

Francesco Tisiot

Mastodon Francesco comes from Verona, Italy and works as a Staff Developer Advocate at Aiven. With his many years of experience as a data analyst, he has stories to tell and advice for data-wranglers everywhere. Francesco loves sharing knowledge with others as a speaker and writer, and is on a mission to defend the world from bad Italian food!