SELECT  * FROM crosstab
 ('SELECT caso_id, inst,caso_entidad_id,actualizacion,nombre,tipo_nombre as fc
     FROM base_clientes order by 1,2',
'SELECT DISTINCT tipo_nombre FROM base_clientes ORDER BY 1')

 AS (caso_id uuid,
    institution varchar(20),
    case_entity_id uuid,
    update_date time,
    people_age text,
    people_first_surname text,
    people_gender text,
    people_name text,
    people_second_surname text,
    people_type text);