ftisiot ideas about food and life
who talks suggestions soft json-pg json-mysql

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.

Continue Reading

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.

Continue Reading


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!

Story logo

© 2023