New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

【Q024】在 postgres 中，查询时如何对 jsonb 数据格式化 #25

Open

shfshanyue opened this issue Nov 11, 2019 · 1 comment

Labels

db

Owner

shfshanyue commented Nov 11, 2019

No description provided.

shfshanyue added the db label

Owner Author

shfshanyue commented Nov 11, 2019 •

edited

使用 jsonb_pretty 函数，示例如下

> select jsonb_pretty('{"a": {"b": 4}}'::jsonb)
+----------------+
| jsonb_pretty   |
|----------------|
| {              |
|     "a": {     |
|         "b": 4 |
|     }          |
| }              |
+----------------+
SELECT 1
Time: 0.018s

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment