> This page location: JSON Functions > jsonb_path_exists > Full Neon documentation index: https://neon.com/docs/llms.txt # PostgreSQL jsonb_path_exists() Function **Summary**: in this tutorial, you will learn how to use the PostgreSQL `jsonb_path_exists()` function to check if a JSON path returns any item for a specified JSON document. ## Introduction to the PostgreSQL jsonb_path_exists() function The `jsonb_path_exists()` function allows you to check if a JSON path matches any element in a JSON document. Here's the syntax of the `jsonb_path_exists()` function: ```sql jsonb_path_exists(jsonb_data, json_path) ``` In this syntax: - `jsonb_data` is a JSON document where you want to check for a JSON path. - `json_path` is the path that you want to check. The `jsonb_path_exists()` function returns true if the `json_path` returns any elements in the `jsonb_data` document or false otherwise. ## PostgreSQL jsonb_path_exists() function example Let's take some examples of using the `jsonb_path_exists()` function. ### Setting up a sample table First, [create a new table](../postgresql-tutorial/postgresql-create-table) called `products` that store product information: ```sql CREATE TABLE products ( id SERIAL PRIMARY KEY, name VARCHAR(100) NOT NULL, attributes JSONB ); ``` The `products` table has the `attributes` column whose data type is `JSONB`. Second, [insert rows](../postgresql-tutorial/postgresql-insert-multiple-rows) into the `products` table: ```sql INSERT INTO products (name, attributes) VALUES ('Laptop', '{"brand": "Dell", "price": 1200, "specs": {"cpu": "Intel i7", "ram": "16GB"}}'), ('Smartphone', '{"brand": "Samsung", "price": 800, "specs": {"os": "Android", "storage": "128GB"}}') RETURNING *; ``` Output: ```text id | name | attributes ----+------------+------------------------------------------------------------------------------------ 1 | Laptop | {"brand": "Dell", "price": 1200, "specs": {"cpu": "Intel i7", "ram": "16GB"}} 2 | Smartphone | {"brand": "Samsung", "price": 800, "specs": {"os": "Android", "storage": "128GB"}} (2 rows) ``` ### 1) Basic jsonb_path_exists() function example The following example uses the `jsonb_path_exists()` function to check whether the CPU specification exists for any product: ```sql SELECT name, jsonb_path_exists(attributes, '$.specs.cpu') AS cpu_exists FROM products; ``` Output: ```text name | cpu_exists ------------+------------ Laptop | t Smartphone | f (2 rows) ``` ### 2) Using the jsonb_path_exists() function in the WHERE clause The following example uses the `jsonb_path_exists()` function with the [`jsonb_path_query()`](https://neon.com/postgresql/postgresql-json-functions/postgresql-jsonb_path_query) function to retrieve the `CPU` specification of any products that have `CPU` spec: ```sql SELECT jsonb_path_query(attributes, '$.specs.cpu') AS cpu FROM products WHERE jsonb_path_exists(attributes, '$.specs.cpu'); ``` Output: ```text cpu ------------ "Intel i7" (1 row) ``` ## Summary - Use the `jsonb_path_exists()` function to check the existence of JSON Path expressions within JSONB data --- ## Related docs (JSON Functions) - [Extracting JSON Data](https://neon.com/postgresql/postgresql-json-functions/postgresql-json-extract) - [JSONB Operators](https://neon.com/postgresql/postgresql-json-functions/postgresql-jsonb-operators) - [jsonb_agg](https://neon.com/postgresql/postgresql-json-functions/postgresql-jsonb_agg) - [jsonb_array_elements](https://neon.com/postgresql/postgresql-json-functions/postgresql-jsonb_array_elements) - [jsonb_array_elements_text](https://neon.com/postgresql/postgresql-json-functions/postgresql-jsonb_array_elements_text) - [jsonb_array_length](https://neon.com/postgresql/postgresql-json-functions/postgresql-jsonb_array_length) - [jsonb_build_array](https://neon.com/postgresql/postgresql-json-functions/postgresql-jsonb_build_array) - [jsonb_build_object](https://neon.com/postgresql/postgresql-json-functions/postgresql-jsonb_build_object) - [jsonb_each](https://neon.com/postgresql/postgresql-json-functions/postgresql-jsonb_each) - [jsonb_each_text](https://neon.com/postgresql/postgresql-json-functions/postgresql-jsonb_each_text) - [jsonb_extract_path](https://neon.com/postgresql/postgresql-json-functions/postgresql-jsonb_extract_path) - [jsonb_extract_path_text](https://neon.com/postgresql/postgresql-json-functions/postgresql-jsonb_extract_path_text) - [jsonb_insert](https://neon.com/postgresql/postgresql-json-functions/postgresql-jsonb_insert) - [jsonb_object](https://neon.com/postgresql/postgresql-json-functions/postgresql-jsonb_object) - [jsonb_object_agg](https://neon.com/postgresql/postgresql-json-functions/postgresql-jsonb_object_agg) - [jsonb_object_keys](https://neon.com/postgresql/postgresql-json-functions/postgresql-jsonb_object_keys) - [JSON Path](https://neon.com/postgresql/postgresql-json-functions/postgresql-json-path) - [jsonb_path_query](https://neon.com/postgresql/postgresql-json-functions/postgresql-jsonb_path_query) - [jsonb_path_query_array](https://neon.com/postgresql/postgresql-json-functions/postgresql-jsonb_path_query_array) - [jsonb_path_query_first](https://neon.com/postgresql/postgresql-json-functions/postgresql-jsonb_path_query_first) - [jsonb_pretty](https://neon.com/postgresql/postgresql-json-functions/postgresql-jsonb_pretty) - [jsonb_set](https://neon.com/postgresql/postgresql-json-functions/postgresql-jsonb_set) - [jsonb_strip_nulls](https://neon.com/postgresql/postgresql-json-functions/postgresql-jsonb_strip_nulls) - [jsonb_to_record](https://neon.com/postgresql/postgresql-json-functions/postgresql-jsonb_to_record) - [jsonb_populate_record](https://neon.com/postgresql/postgresql-json-functions/postgresql-jsonb_populate_record) - [jsonb_populate_recordset](https://neon.com/postgresql/postgresql-json-functions/postgresql-jsonb_populate_recordset) - [jsonb_typeof](https://neon.com/postgresql/postgresql-json-functions/postgresql-jsonb_typeof) - [row_to_json](https://neon.com/postgresql/postgresql-json-functions/postgresql-row_to_json) - [to_jsonb](https://neon.com/postgresql/postgresql-json-functions/postgresql-to_jsonb)