I don't understand which kind of format I have my data. The column name is wkb_geom, so I supposed that data were in WKB format, but then I was checking around and I couldn't find example of it. Data are like this:
Is it in WKB or WKT format?? Second question, in case it's in WKB format, how can I convert it into WKT format? I was trying to follow this suggestion
so the query is
UPDATE "ita_adm1" SET wkb_geometry = ST_GeomFromWKB("wkb_geometry",4326)
but it keeps saying that the function ST_GeomFromWKB doesn't exist.