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 every so often, and it's not used anywhere else in the 
application, so I'm going to store it in a JSONB column, with a schema 
stored (also in JSONB) in a separate table which can be used to validate 
the data. I'll have a version number on the schema, and this will be 
kept in the student record also.

Ray.

-- 
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie