> This page location: JSON Functions > jsonb_array_elements_text
> Full Neon documentation index: https://neon.com/docs/llms.txt

# PostgreSQL jsonb_array_elements_text() Function

**Summary**: in this tutorial, you will learn how to use the PostgreSQL `jsonb_array_elements_text()` function to expand the elements of a top-level JSON array into a set of text values.

## Introduction to the PostgreSQL jsonb_array_elements_text() function

The `jsonb_array_elements_text()` function allows you to expand the elements of a top-level [JSON](../postgresql-tutorial/postgresql-json) array into a set of JSON values.

The following shows the basic syntax of the `jsonb_array_elements_text()` function:

```sql
jsonb_array_elements_text(json_array)
```

In this syntax:

- `json_array` is a JSON array with the `JSONB` type, which you want to expand the elements.

The `jsonb_array_elements_text()` function will expand the elements in the `json_array` into individual text values.

If you pass an object to the function, it'll issue an error. In case the `json_array` is `NULL`, the function returns an empty result set.

## PostgreSQL jsonb_array_elements_text() function examples

Let's take some examples of using the `jsonb_array_elements_text()` function.

### 1) Basic PostgreSQL jsonb_array_elements_text() function examples

The following example uses the `jsonb_array_elements_text()` function to expand elements of a JSON array:

```sql
SELECT jsonb_array_elements_text('["orange","banana","watermelon"]');
```

Output:

```text
 jsonb_array_elements_text
---------------------------
 orange
 banana
 watermelon
(3 rows)
```

The following example uses the `jsonb_array_elements_text()` function to expand an array of numbers:

```sql
SELECT jsonb_array_elements_text('[1,2,3]');
```

Output:

```text
 jsonb_array_elements_text
---------------------------
 1
 2
 3
(3 rows)
```

Note that 1, 2, and 3 are text values, not numbers. To convert them to numbers, you need to have an explicit cast.

### 2) Using the jsonb_array_elements_text() function with nested arrays example

The following example uses the `jsonb_array_elements_text()` function to expand elements of an array that contains another array:

```sql
SELECT jsonb_array_elements_text('[1,2,3, [4,5], 6]');
```

Output:

```text
 jsonb_array_elements_text
---------------------------
 1
 2
 3
 [4, 5]
 6
(5 rows)
```

### 3) Using the jsonb_array_elements_text() function with table data

First, [create a table](../postgresql-tutorial/postgresql-create-table) called `employees`:

```sql
CREATE TABLE employees (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    skills JSONB
);
```

The `skills` column has the JSONB type, which stores the skills of employees.

Second, [insert some rows](../postgresql-tutorial/postgresql-insert-multiple-rows) into the `employees` table:

```sql
INSERT INTO employees (name, skills)
VALUES
('John Doe', '["Java", "Python", "SQL"]'),
('Jane Smith', '["C++", "JavaScript", "HTML/CSS"]'),
('Alice Johnson', '["Python", "Data Analysis", "Machine Learning"]'),
('Bob Brown', '["Java", "SQL", "Spring Framework"]');
```

Third, retrieve all skills of employees:

```sql
SELECT jsonb_array_elements_text(skills) skills
FROM employees;
```

Output:

```text
      skills
------------------
 Java
 Python
 SQL
 C++
 JavaScript
 HTML/CSS
 Python
 Data Analysis
 Machine Learning
 Java
 SQL
 Spring Framework
(12 rows)
```

It returns 12 skills as text values.

If you want to get unique skills, you can use the [`DISTINCT`](../postgresql-tutorial/postgresql-select-distinct) operator:

```sql
SELECT DISTINCT jsonb_array_elements_text(skills) skills
FROM employees;
```

Output:

```text
      skills
------------------
 Data Analysis
 C++
 JavaScript
 SQL
 Python
 Machine Learning
 Spring Framework
 HTML/CSS
 Java
(9 rows)
```

## Summary

- Use the `jsonb_array_elements_text()` function to expand elements of the top-level JSON array into a set of text values.

---

## 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_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_exists](https://neon.com/postgresql/postgresql-json-functions/postgresql-jsonb_path_exists)
- [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)