Re: How is JSON stored in PG ?

On Tue, 2021-11-16 at 10:54 -0500, David Gauthier wrote: > Hi: > > psql (11.5, server 11.3) on linux > > I'm considering using JSON as a datatype for something I'm working on.  The > reasons are... > > 1) the 'metadata' (if you want to call it that) in JSON is very flexible.  > Doesn't require

Re: How is JSON stored in PG ?

On 16/11/2021 15:54, David Gauthier wrote: Pros and Cons for using JSON ? If it helps, here's my current use-case. I'm currently working on a project wherein data is captured from students for eventual submission to the relevant government department. The exact set of data required changes

Re: How is JSON stored in PG ?

On 11/16/21 07:54, David Gauthier wrote: Hi: psql (11.5, server 11.3) on linux I'm considering using JSON as a datatype for something I'm working on. The reasons are... 1) the 'metadata' (if you want to call it that) in JSON is very flexible.  Doesn't require an alter table or anything lik

How is JSON stored in PG ?

Hi: psql (11.5, server 11.3) on linux I'm considering using JSON as a datatype for something I'm working on. The reasons are... 1) the 'metadata' (if you want to call it that) in JSON is very flexible. Doesn't require an alter table or anything like that to change. 2) The customers for this dat