Zet - How can I get WKT from a WKB column?

How can I get WKT from a WKB column?

You can use ST_AsText(column)

Example

select ST_AsText(location) from asset limit 1;

Also can be cast to GeoJson

select ST_AsGeoJson(location) from asset limit 1;

#postgis