Schemaless Postgres

schemaless_postgres.txt

psql=# create table schemaless (
  id json,
  email json,
  active json,
  name json,
  subscription json
);
CREATE TABLE


              Table "public.schemaless"
    Column    | Type | Collation | Nullable | Default
--------------+------+-----------+----------+---------
 id           | json |           |          |
 email        | json |           |          |
 active       | json |           |          |
 name         | json |           |          |
 subscription | json |           |          |
 
 
psql=# insert into schemaless (id, email, active, name, subscription) values
(
'{"id": 42}',
'{"email": "[email protected]"}',
'{"active": true}',
'{"name": "Fred Flintstone"}',
'{"subscription": "Omega Tier!"}'
);

psql=# \x
Expanded display is on.

psql=# select * from schemaless limit 1;
-[ RECORD 1 ]+--------------------------------
id           | {"id": 42}
email        | {"email": "[email protected]"}
active       | {"active": true}
name         | {"name": "Fred Flintstone"}
subscription | {"subscription": "Omega Tier!"}