| Sql |
select * from
(select 'dir' as estrazione, a.nome::text,
(json_object_keys(a.valore_n::json))::text AS campo,
(a.valore_n::json -> json_object_keys(a.valore_n::json))::text AS valore_n, vat_number from
(select
b.nome, b.valore_n, vat_number from
(select vat_number, (json_object_keys(financial_data::json))::text AS nome,
(financial_data::json -> json_object_keys(financial_data::json))::text AS valore_n
from reports) b ) a) pippo where pippo.valore_n !~ ('{')
union
select 'ann' as estrazione, k.nome::text,
(json_object_keys(k.valore_n::json))::text AS campo,
(k.valore_n::json -> json_object_keys(k.valore_n::json))::text AS valore_n, vat_number from
(select * from
(select a.nome::text,
(json_object_keys(a.valore_n::json))::text AS campo,
(a.valore_n::json -> json_object_keys(a.valore_n::json))::text AS valore_n, vat_number from
(select
b.nome, b.valore_n, vat_number from
(select vat_number, (json_object_keys(financial_data::json))::text AS nome,
(financial_data::json -> json_object_keys(financial_data::json))::text AS valore_n
from reports) b ) a) pippo where pippo.valore_n ~ ('{')) k
|
