# pqJQ - Postgres에서 jq 사용하기

> Clean Markdown view of GeekNews topic #14310. Use the original source for factual precision when an external source URL is present.

## Metadata

- GeekNews HTML: [https://news.hada.io/topic?id=14310](https://news.hada.io/topic?id=14310)
- GeekNews Markdown: [https://news.hada.io/topic/14310.md](https://news.hada.io/topic/14310.md)
- Type: news
- Author: [xguru](https://news.hada.io/@xguru)
- Published: 2024-04-14T09:37:02+09:00
- Updated: 2024-04-14T09:37:02+09:00
- Original source: [github.com/Florents-Tselai](https://github.com/Florents-Tselai/pgJQ)
- Points: 9
- Comments: 0

## Topic Body

- jq 컴파일러를 Postgres에 내장하게 해주는 확장   
- `jqprog` 데이터 타입을 추가 하고 `jq(jsonb, jqprog)` 함수를 추가해서 `jsonb` 개체에 실행 가능   
  - 표준 `jsonb` 함수, 연산자 및 `jsonpath`와 원활하게 연동됨   
- `SELECT jq('[{"bar": "baz", "balance": 7.77, "active":false}]'::jsonb, '.[0].bar');`

## Comments



_No public comments on this page._