jsonb_object_agg()

Collects all the key/value pairs into a JSON object. Key arguments are coerced to text; value arguments are converted as per to_json or to_jsonb. Values can be null, but keys cannot.

Signature

jsonb_object_agg ( key "any", value "any" ORDER BY input_sort_columns ) → jsonb

Examples

SELECT jsonb_object_agg(product, quantity) FROM orders WHERE region = 'east';

      jsonb_object_agg       
-----------------------------
 {"cable": 10, "monitor": 2}
(1 row)

Run against PostgreSQL 18.6 on 2026-09-13. This is the output we got, not the documentation’s.

Want to run this against your own PostgreSQL server from an iPhone, iPad or Mac? These are ours — every connection goes straight from the device to your database, with no account and no server of ours in between.

Postgres & FriendsPostgreSQL and the open-source engines around it

Signature and description adapted from the PostgreSQL manual, used under the PostgreSQL License. PostgreSQL is a registered trademark of the PostgreSQL Community Association of Canada. This page is not affiliated with the PostgreSQL Global Development Group.