Delphi – PostgreSQL – JSON

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;

Laisser un commentaire

Votre adresse e-mail ne sera pas publiée.