Re: Convert JSON value back to postgres representation

2025-06-20 Thread Phillip Diffley
Good to know. Thank you! On Fri, Jun 20, 2025 at 7:17 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Thursday, June 19, 2025, Laurenz Albe wrote: > >> On Thu, 2025-06-19 at 23:05 +0200, Phillip Diffley wrote: >> > Postgres has a to_jsonb function that will convert a value into it

Re: Convert JSON value back to postgres representation

2025-06-19 Thread David G. Johnston
On Thursday, June 19, 2025, Laurenz Albe wrote: > On Thu, 2025-06-19 at 23:05 +0200, Phillip Diffley wrote: > > Postgres has a to_jsonb function that will convert a value into its > jsonb representation. > > I am now trying to turn a json value back into its postgres type. I was > hoping there wo

Re: Convert JSON value back to postgres representation

2025-06-19 Thread Laurenz Albe
On Thu, 2025-06-19 at 23:05 +0200, Phillip Diffley wrote: > Postgres has a to_jsonb function that will convert a value into its jsonb > representation. > I am now trying to turn a json value back into its postgres type. I was > hoping there would > be something like a from_jsonb function that, al