Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table "Example" (raw json);
insert into "Example" select null from generate_series(1,2e3);
insert into "Example" values
('{"type":"Eg","device":"Eg","value":1,"timestamp":"2024-02-23T05:51:19Z"}')
returning jsonb_pretty(raw::jsonb);

CREATE TABLE

INSERT 0 2000

jsonb_pretty

{
    "type": "Eg",
    "value": 1,
    "device": "Eg",
    "timestamp": "2024-02-23T05:51:19Z"
}

INSERT 0 1

SELECT
   ex.raw->>'type'
FROM 
   "Example" ex
LIMIT 3;

?column?

null

null

null

SELECT 3

SELECT
   ex.raw->>'type'
FROM 
   "Example" ex
ORDER BY 1 NULLS LAST
LIMIT 3;

?column?

Eg

null

null

SELECT 3

?column?
null
null
null

?column?
Eg
null
null