Paste this into a new question or an answer at dba.stackexchange.com:
<!-- --> > CREATE TABLE json_table( > id serial, > data jsonb > ); > > INSERT INTO json_table(id, data) > VALUES > (1, '"String is OK"'), > (2, '123213'), > (3, '-123123'), > (4, '213.12'), > (5, '{"hello": "world"}'), > (6, '[1, 2, 3]'); > > <pre> > ✓ > 6 rows affected > </pre> <!-- --> > SELECT * FROM json_table; > > <pre> > id | data > -: | :----------------- > 1 | &quot;String is OK&quot; > 2 | 123213 > 3 | -123123 > 4 | 213.12 > 5 | {&quot;hello&quot;: &quot;world&quot;} > 6 | [1, 2, 3] > </pre> *db<>fiddle [here](https://dbfiddle.uk/?rdbms=postgres_11&fiddle=e3328babe5d590cadb6455ec9966ca20)*
back to fiddle