transformServers.sql

gistfile1.txt

-- transforms JSONB row data to columns
CREATE OR REPLACE FUNCTION transformServers(data jsonb)
RETURNS SETOF RECORD as $$
DECLARE
serversSet  RECORD;

BEGIN
   return query
      SELECT jsonb_to_recordset(data->'data') INTO
      serversSet (
      id bigint,
      hostname text,
      nickname text,
      os text,
      created text,
      running text,
      capacity_cpu_freq text,
      description text,
      location_ip text,
      capacity_cpu_num text,
      capacity_mem text,
      current_version text,
      os_detail text,
      architecture text,
      guid text,
      capacity_disk jsonb,
      network_interfaces jsonb,
      url text
      );

END;
$$ language plpgsql;