---
title: "Discussion on \"Update table according with JSON/JSONB\" | Hashnode"
description: "Discussion on \"Update table according with JSON/JSONB\". Question:\nI have a table books :\n\n\n\n\nName of columnType\n\n\n\nidint (PK)\n\nnametext\n\nnb_pagesint\n\n\nAnd a table book_modifications :\n\n\n\n\nName of columnType\n\n\n\nidint (PK)\n\nold_datajsonb\n\nnew_datajsonb\n\nbook_idint (FK)\n\n\nNow let's imagine I have a row in my..."
url: "https://hashnode.com/posts/update-table-according-with-jsonjsonb/686fbe35e5d14f3197ab2e53"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Update table according with JSON/JSONB](https://databasedev.hashnode.dev/update-table-according-with-jsonjsonb?utm_source=hashnode&utm_medium=feed)

Question: I have a table books : Name of columnType idint (PK) nametext nb\_pagesint And a table book\_modifications : Name of columnType idint (PK) old\_datajsonb new\_datajsonb book\_idint (FK) Now let's imagine I have a row in my...

Jul 10, 2025 · 2 min read · databasedev.hashnode.dev  
Read the article

-   [#sql](https://hashnode.com/tag/sql)
-   [#json](https://hashnode.com/tag/json)
-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#qanda](https://hashnode.com/tag/qanda)
-   [#databases](https://hashnode.com/tag/databases)

## Written by

[Gabriella Barajas](https://hashnode.com/@gabbbybar)

@gabbbybar · USA

  
[View profile](https://hashnode.com/@gabbbybar)

Real Questions. Clean Answers. All About Databases.

A database Q&amp;A blog for those who’d rather debug queries than read documentation. Practical answers to real questions — mostly SQL Server and MySQL, with a pinch of sarcasm and a love for clean code.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
