PostgreSQL is becoming increasingly powerful. It has been the standard for new, innovative transactional systems for years, and now we see growing acceptance of PostgreSQL as an analytics solution.
postgres-json-schema allows validation of JSON schemas in PostgreSQL. It is implemented as a PL/pgSQL function and you can use it as a check constraint to validate the format of your JSON columns.
-> CHAR datatype can store: A-Z, a-z, 0-9,Special Characters -> in string format. -> Whenever we use CHAR, we must specify its size. -> Syntax : CHAR(size) -> Example: CHAR(10) -> Characteristics ...