Re: [racket-users] Storing JSON into PostgreSQL 10

Yep, that does it. Apparently I was overcomplicating things. Thanks! On Fri, Mar 16, 2018 at 8:12 PM, Ryan Culpepper wrote: > On 03/16/2018 11:28 PM, David Storrs wrote: > >> I'm noticing that when I store jsexpr?s into PostgreSQL 10 I end up with >> them as strings, not as

Re: [racket-users] Storing JSON into PostgreSQL 10

On 03/16/2018 11:28 PM, David Storrs wrote: I'm noticing that when I store jsexpr?s into PostgreSQL 10 I end up with them as strings, not as actual JSONB data.  I've read the docs and tried every combination of typecasting / methods of writing that I can think of but nothing ends up working. 

Re: [racket-users] Storing JSON into PostgreSQL 10

I suspect this may be an issue with your PostgreSQL schema. Racket uses the `jsexpr?` type for both the types "JSON" and "JSONB" at the PostgreSQL level.[1] Can you confirm that your column is defined with the "JSONB" type? [1]

[racket-users] Storing JSON into PostgreSQL 10

I'm noticing that when I store jsexpr?s into PostgreSQL 10 I end up with them as strings, not as actual JSONB data. I've read the docs and tried every combination of typecasting / methods of writing that I can think of but nothing ends up working. Can anyone point me to the right way? -- You