Determine Types Of JSONB Records
You can stick several different things into a JSONB postgres column.
Possible types are object, array, string, number, boolean, and null.
If you are trying to audit what is in them, you might reach for:
That is just gonna spit out jsonb
over and over, like, I already know that.
What you really want to know is, is the top-level thing an object, an array, or maybe just a string or number. There are specific JSON processing functions for this, json_typeof
and jsonb_typeof
which you can call like so:
Last updated