[GTALUG] JSON Standard for SQL Thoughts

Dave Cramer davecramer at gmail.com
Mon Jun 8 07:53:20 EDT 2020


On Sun, 7 Jun 2020 at 22:34, Nicholas Krause via talk <talk at gtalug.org>
wrote:

>
>
> On 6/6/20 3:07 AM, William Park via talk wrote:
> > Last time I read, it was just string blob, and the JSON is parsed every
> > time to extract something inside.
> >
> After reading parts of the docs seems JSONB is the version your talking
> about. However JSON seems to be the second type and there seems to be
> some differences.
>
> Not sure if I'm reading this right. JSONB is not parsed every time. JSON
is. That said I doubt anyone really uses the JSON type in PostgreSQL any
more



Dave Cramer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://gtalug.org/pipermail/talk/attachments/20200608/69d510e9/attachment.html>


More information about the talk mailing list