I'm new to QGIS and I'm using PostGreSQL and QGIS DB Manager to get information from the polygon_osm tables.
I'm currently working on the _polygon table and I'd like to get the coordinates for each point in the polygons.
Here is the problem I am facing:
I am trying to figure out what the "way" field is. When I display the whole table it says "POLYGON" and when I display a specific entry I have very long series of numbers and letters (0-9, A-F) like "0103000020110F00000100000051010000713D0AD7BBDCB..."
and so on (fewer zeros on the right). I'm looking for a way to get a human-readable field, by which I mean coordinates of the points specifying the vertices of the polygon, or id linked to another table (I'm not sure what is stored in this field). The field type is geometry(Geometry,3857). I have a warning message saying "There is no entry in geometry_columns!", I don't know if it is related.
The geom_to_wkt function seems to be what I'm looking for but I am working on tables with millions of entries so I need to do this with a query in DB Manager and not just in the field calculator of the attribute table.