Re: BUG #16092: json[b]_to_recordset and json[b]_populate_record do not read properties with mixed-case names - Mailing list pgsql-bugs

Hello

Its correct. Identifier name definition should be quoted if you want use uppercase symbols:

SELECT x.* FROM jsonb_to_recordset('[{"aName": "foo"}]'::jsonb) AS x("aName" text);

 aName 
-------
 foo

unquoted names are always folded to lower case and therefore do not match. Per lexical structure documentation:
https://www.postgresql.org/docs/current/sql-syntax-lexical.html

regards, Sergei