Skip to main content
Released

Add JSONB data type to PostGresql

Related products:FME Form
  • April 22, 2024
  • 2 replies
  • 56 views

fmelizard
Safer
Forum|alt.badge.img+22
Migration Note: Idea originally posted on 2015-10-29
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

djmcdermott
Contributor
Forum|alt.badge.img+7
  • Contributor
  • April 22, 2024
I am looking at storing JSON responses in my existing postgreSQL DB rather than having to install and learn MongoDB or another NSQL DB. This would be a great addition.

Forum|alt.badge.img+4
We are processing e-forms which Drupal fires to FME Cloud. The e-form content arrives as JSON and whilst FME can write JSON formatted text to a JSON datatype in Postgres it can't write native JSONB datatypes to Postgres yet. JSONB provides a lot of advantages (like being able to add indexes etc) and seeing this support in FME would significantly enhance it's JSON capabilities.