Skip to main content

jsonb_exists_path

jsonb_exists_path​

description​

It is used to judge whether the field specified by json_path exists in the JSONB data. If it exists, it returns TRUE, and if it does not exist, it returns FALSE

Syntax​

BOOLEAN jsonb_exists_path(JSONB j, VARCHAR json_path)

example​

Refer to jsonb tutorial

keywords​

jsonb_exists_path