How to JSON in PostgreSQL®
Tags: postgres, json, query, sql
Published: 2023-01-10 15:07:00

---
title: How to JSON in PostgreSQL®
published: true
date: 2023-01-10 15:07:00 UTC
tags: postgresql, json, query, sql
canonical_url: https://ftisiot.net/postgresqljson/main/
---

This series covers how to solve common problems on JSON datasets with PostgreSQL® and it includes (links will appear once the target pages are up):

### Common JSON questions

* [What are the differences between JSON or JSONB in PostgreSQL?](https://ftisiot.net/postgresqljson/what-are-the-differences-json-jsonb-postgresql)
* How to load JSON data in PostgreSQL?

### Parse JSON

* [How to extract a field from a JSON object in PostgreSQL?](https://ftisiot.net/postgresqljson/how-to-extract-field-from-json-postgresql)
* [How to get the JSON field types in PostgreSQL?](https://ftisiot.net/postgresqljson/how-to-get-json-field-types-postgresql)
* [How to check if JSON contains in PostgreSQL?](https://ftisiot.net/postgresqljson/how-to-check-JSON-contains-postgresql)
* How does JSON path work in PostgreSQL?
* [How to parse JSON arrays in PostgreSQL?](https://ftisiot.net/postgresqljson/how-to-parse-json-arrays-in-postgresql)
* [How to parse JSON keys in PostgreSQL?](https://ftisiot.net/postgresqljson/how-to-parse-json-keys-postgresql)

### Tabulate JSON to record or recordset

* [How to tabulate a JSON to a record in PostgreSQL?](https://ftisiot.net/postgresqljson/how-to-tabulate-json-document-to-a-record-postgresql)
* [How to tabulate a JSON to a recordset in PostgreSQL?](https://ftisiot.net/postgresqljson/how-to-tabulate-json-document-to-a-recordset-postgresql)

### Convert to JSON

* [How to convert a row to JSON in PostgreSQL?](https://ftisiot.net/postgresqljson/how-to-convert-table-row-json-postgresql)
* [How to create a JSON object from keys and values arrays in PostgreSQL?](https://ftisiot.net/postgresqljson/howto-create-json-from-keys-and-values-arrays-postgresql)
* [How to create a JSON object from array of key/value pairs in PostgreSQL?](https://ftisiot.net/postgresqljson/howto-create-json-from-array-key-value-pairs-postgresql)
* [How to build a JSON array from a list of elements in PostgreSQL?](https://ftisiot.net/postgresqljson/how-to-build-json-array-from-elements-postgresql)
* [How to convert an array to a JSON array in PostgreSQL?](https://ftisiot.net/postgresqljson/howto-convert-array-to-json-array-postgresql)


### Prettify JSON output

* [How to prettify the JSON output in PostgreSQL?](https://ftisiot.net/postgresqljson/how-to-prettify-json-output-in-postgresql)

### Edit JSON

* [How to concatenate two JSON documents in PostgreSQL?](https://ftisiot.net/postgresqljson/how-to-concatenate-two-json-docs-postgresql)
* [How to remove fields from a JSON document in PostgreSQL?](https://ftisiot.net/postgresqljson/how-to-remove-fields-from-json-postgresql)
* [How to remove an item from a JSON array in PostgreSQL?](https://ftisiot.net/postgresqljson/how-to-remove-items-from-json-array-postgresql)
* [How to remove nulls JSON object in PostgreSQL?](https://ftisiot.net/postgresqljson/how-to-remove-nulls-from-json-postgresql)
* [How to edit a JSON document in PostgreSQL?](https://ftisiot.net/postgresqljson/how-to-edit-json-postgresql)