JSON

TO_JSONB

PostgreSQL

Mengkonversi nilai PostgreSQL ke JSONB. Bisa mengkonversi scalar, array, composite type, dan record. TO_JSONB lebih disarankan karena performa lebih baik.

Tipe hasil: jsonb

Syntax

SQL

TO_JSONB(any_value)
TO_JSON(any_value)

Parameter

any_valueanywajib

Nilai yang akan dikonversi ke JSON

Contoh Penggunaan

Konversi Scalar Values

SQL

1 SELECT 
2   TO_JSONB(Hello::text) AS text_val,
3   TO_JSONB(123) AS int_val,
4   TO_JSONB(true) AS bool_val,
5   TO_JSONB(ARRAY[1,2,3]) AS array_val;

Mengkonversi berbagai tipe data ke JSONB.

Hasil

text_val	int_val	bool_val	array_val
"Hello"	123	true	[1, 2, 3]

Konversi Row ke JSON

SQL

1 SELECT TO_JSONB(users.*) AS user_json
2 FROM users
3 WHERE id = 1;

Mengkonversi seluruh row menjadi JSON object.

Hasil

user_json
{"id": 1, "name": "John", "email": "..."}

Build JSON Response

SQL

1 SELECT TO_JSONB(ROW(
2   success::text,
3   COUNT(*)::int,
4   ARRAY_AGG(name)
5 )) AS response
6 FROM products;

Membuat JSON response dari query result.

Fungsi Equivalen di Database Lain

TO_JSON

Snowflake

TO_JSON

BigQuery

TO_JSON

DuckDB

Fungsi Terkait

JSONB_BUILD_OBJECTJSONB_BUILD_ARRAYTO_JSON

Kembali ke PostgreSQL Functions

1	SELECT
2	TO_JSONB(Hello::text) AS text_val,
3	TO_JSONB(123) AS int_val,
4	TO_JSONB(true) AS bool_val,
5	TO_JSONB(ARRAY[1,2,3]) AS array_val;

1	SELECT TO_JSONB(users.*) AS user_json
2	FROM users
3	WHERE id = 1;

1	SELECT TO_JSONB(ROW(
2	success::text,
3	COUNT(*)::int,
4	ARRAY_AGG(name)
5	)) AS response
6	FROM products;