SELECT gid, strasse, hnr, astext(the_geom), ort FROM kundenorte LIMIT 1; gid | strasse | hnr | astext | ort ------+---------------+-----+-------------------------------+----------- 49482 | Friedhofplatz | 5 | POINT(7.53550005 47.20740128) | Solothurn