Postgres Pro
Downloads
Home   >   mailing lists

best way to convert JSONB object from result - Mailing list pgsql-jdbc

From Tom Smith
Subject best way to convert JSONB object from result
Date
Msg-id CAKwSVFGcWsupX6mhEgPaZmnAXcaELv7WY7souWbM7Czo3iCkCg@mail.gmail.com
Whole thread Raw
Responses Re: best way to convert JSONB object from result
Re: best way to convert JSONB object from result
List pgsql-jdbc
Tree view
Hi:

I am trying to convert to a Java or Map object
from resultset with a jsonb column.
Currently, I am using

String jsonString = resultSet.getString("jsonb_column_name")

then I convert from jsonString to a Map<String,Object>  or a Java class object.

This is obviously inefficient.  What would be most efficient (not too complicated)

Thanks in Advance

pgsql-jdbc by date:

Previous
From: rcohen@e1b.org
Date:
Subject: Re: sql type reported for enum
Next
From: Dave Cramer
Date:
Subject: Re: sql type reported for enum