From: | Ronnie Taib <geppub(at)hotmail(dot)com> |
---|---|
To: | "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
Subject: | pgAdmin4 not displaying geometry details nicely (for a GIS table) |
Date: | 2017-02-02 01:57:26 |
Message-ID: | SY3PR01MB16411520687980E1767FDC40A34C0@SY3PR01MB1641.ausprd01.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hi all,
I'm a newbie here, so I hope this message is relevant to this forum. I posted it in gis.stackexchange (http://gis.stackexchange.com/q/226578/90727) but I guess it belongs to the pgAdmin4 developers, really.
Basically, there is a difference of behaviour between pgAdminIII and pgAdmin4 in the SQL pane when it comes to showing the details of a PostGIS geometry column. For example, pgAdminIII would show `geom geometry(LineStringZ,28356)` which is useful to immediately identify the type and SRID of the geometry. For the same table, pgAdmin4 shows `geom geometry(7259142)`.
Someone indicated that 7259142 is a binary concatenation of the LineStringZ code (00000110) and the SRID, but even so, it is very inconvenient quickly check table definitions in pgAdmin4.
Again, I am not sure whether this belongs to pgAdmin devs, to PostGIS devs, or to someone else. I just thought I'd raise the issue, as it made me revert to pgAdminIII...
Thanks,
Gep
From | Date | Subject | |
---|---|---|---|
Next Message | A.J.L.R. Hasekamp | 2017-02-05 16:22:25 | pgAdmin4 and Archlinux |
Previous Message | Dan Davis | 2017-02-01 20:53:59 | Re: pgadmin4 running behind nginx |