提取Postgresql中的jsonb -字典和同一jsonb字段中的数组结构

{
  "name": "John Doe",
  "age": 30,
  "address": {
    "street": "123 Main St",
    "city": "Anytown"
  }
}

SELECT data->'address' AS address FROM example_table;

{
  "street": "123 Main St",
  "city": "Anytown"
}

{
  "name": "John Doe",
  "age": 30,
  "hobbies": ["reading", "traveling", "sports"]
}

SELECT data->'hobbies' AS hobbies FROM example_table;

["reading", "traveling", "sports"]

CREATE TABLE users (
  id SERIAL PRIMARY KEY,
  info JSONB
);

INSERT INTO users (info) VALUES 
('{"name": "John Doe", "age": 30, "address": {"street": "123 Main St", "city": "Anytown"}}'),
('{"name": "Jane Smith", "age": 25, "hobbies": ["reading", "traveling", "sports"]}');

SELECT id, info->'address' AS address FROM users;

SELECT id, info->'hobbies' AS hobbies FROM users;