> For the complete documentation index, see [llms.txt](https://til.yulrizka.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://til.yulrizka.com/db/postgres-add-object-to-jsonb-array-from-the-same-column.md).

# postgres add object to jsonb array from the same column

We want to create a new column where it's a combination for several column as a jsonb object.

```sql
ALTER TABLE items
	ADD new_arrays_col jsonb DEFAULT '[]';

UPDATE items i1
SET new_arrays_col = new_arrays_col || JSON_BUILD_OBJECT(
		'col1', col1,
		'col1', col2
	)::jsonb
```

the `new_arrays || ...` is kind of like appending to exisitng array with an object. `JSON_BUILD_OBJECT` is a postgres function to create a JSON object from the parameters


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://til.yulrizka.com/db/postgres-add-object-to-jsonb-array-from-the-same-column.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.