Postgres 14

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

select version();

version

PostgreSQL 14.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-20), 64-bit

SELECT 1

CREATE TABLE public.test(
    data jsonb
);

INSERT INTO test (data) VALUES ('{"age":2, "name": "b"}');
INSERT INTO test (data) VALUES ('{"age":1, "name": "cc"}');
INSERT INTO test (data) VALUES ('{"age":4, "name": "d"}');
INSERT INTO test (data) VALUES ('{"age":33, "name": "a"}');

SELECT * FROM test;

CREATE TABLE

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

data

{"age": 2, "name": "b"}

{"age": 1, "name": "cc"}

{"age": 4, "name": "d"}

{"age": 33, "name": "a"}

SELECT 4

SELECT data->>'name' as name, data->>'age' as age 
FROM test
ORDER BY data->'age' ASC;

name
age

cc
1

b
2

d
4

a
33

SELECT 4

SELECT data->>'name' as name, data->>'age' as age 
FROM test
ORDER BY data->'name' ASC;

name
age

a
33

b
2

cc
1

d
4

SELECT 4