JSON

JSONB_BUILD_OBJECT

PostgreSQL

Membuat JSON object dari pasangan key-value. Keys harus text, values bisa tipe apapun. Cara programatik untuk membuat JSON object.

Tipe hasil: jsonb

Syntax

SQL

JSONB_BUILD_OBJECT(key1, value1, key2, value2, ...)

Parameter

key, value pairstext, anywajib

Pasangan key-value untuk object

Contoh Penggunaan

Build Object Sederhana

SQL

1 SELECT JSONB_BUILD_OBJECT(
2   name, John,
3   age, 30,
4   active, true
5 );

Membuat JSON object dari key-value pairs.

Hasil

jsonb_build_object
{"name": "John", "age": 30, "active": true}

Build dari Kolom

SQL

1 SELECT JSONB_BUILD_OBJECT(
2   id, id,
3   full_name, first_name ||   || last_name,
4   metadata, JSONB_BUILD_OBJECT(created, created_at)
5 ) AS user_json
6 FROM users;

Membuat JSON object dari data tabel.

Hasil

user_json
{"id": 1, "full_name": "John Doe", "metadata": ...}

API Response Format

SQL

1 SELECT JSONB_BUILD_OBJECT(
2   status, success,
3   data, JSONB_AGG(JSONB_BUILD_OBJECT(id, id, name, name)),
4   total, COUNT(*)
5 ) AS response
6 FROM products
7 WHERE category = Electronics;

Membuat format response API dengan data dan metadata.

Fungsi Equivalen di Database Lain

JSON_OBJECT

MySQL

OBJECT_CONSTRUCT

Snowflake

JSON_OBJECT

BigQuery

JSON_OBJECT

DuckDB

Fungsi Terkait

JSONB_BUILD_ARRAYTO_JSONTO_JSONB

Kembali ke PostgreSQL Functions

1	SELECT JSONB_BUILD_OBJECT(
2	name, John,
3	age, 30,
4	active, true
5	);

1	SELECT JSONB_BUILD_OBJECT(
2	id, id,
3	full_name, first_name \|\| \|\| last_name,
4	metadata, JSONB_BUILD_OBJECT(created, created_at)
5	) AS user_json
6	FROM users;

1	SELECT JSONB_BUILD_OBJECT(
2	status, success,
3	data, JSONB_AGG(JSONB_BUILD_OBJECT(id, id, name, name)),
4	total, COUNT(*)
5	) AS response
6	FROM products
7	WHERE category = Electronics;