jsonb_type

jsonb_type

description

It is used to determine the type of the field specified by json_path in JSONB data. If the field does not exist, return NULL. If it exists, return one of the following types

• object
• array
• null
• bool
• int
• bigint
• double
• string

Syntax

STRING jsonb_type(JSONB j, VARCHAR json_path)

example

Refer to jsonb tutorial

keywords

jsonb_type