Answer the question
In order to leave comments, you need to log in
What format does PostgreSQL store geometry in?
For some reason, all managers show me the geometry (polygons) in the database in the format:
0106000020F1AD760001000000010300000001000000050000002D043C43F0A76141F7E9CEB140EA63410B31B3F5AAC56141F7E9CEB140EA63410B31B3F5AAC561414A84B4120DBD63412D043C43F0A761414A84B4120DBD63412D043C43F0A76141F7E9CEB140EA6341
Answer the question
In order to leave comments, you need to log in
This is WKB and qGis shows you already in WKT. Postgis has the ST_AsText function which will do the conversion from binary to text representation.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question