Create table with pgjson CREATE TABLE asu_clients_activity_jsonb ( id serial primary key, pg_timestamp timestamp default NULL, data jsonb ); Select from records distink by last timestamp SELECT DISTINCT ON (client_id) pg_timestamp AS “@timestamp”, data->>’client_id’ AS client_id, data->’client.env’->>’asu_hosts_ssl’ AS asu_hosts_ssl, data->>’asu_version’ AS asu_version, data->’asu_clients_activity’->>’companies’ AS companies, data->’asu_clients_activity’->>’users_count’ AS users_count, data->’asu_clients_activity’->>’area_of_houses_thousand(sqm)’ AS area_of_houses_thousand, data->>’global_auth_token’ AS global_auth_token FROM […]
Postgresql jsonb querys
