Here are a few tips to using JSON from Delphi (using Devart’s PgDAC libraries)
Listing Key values from a JSON field
SELECT jsonb_object_keys(data) AS key
FROM bulkdata
WHERE idimport=29
GROUP BY key;
Here are a few tips to using JSON from Delphi (using Devart’s PgDAC libraries)
SELECT jsonb_object_keys(data) AS key
FROM bulkdata
WHERE idimport=29
GROUP BY key;