pgAdmin4 not displaying geometry details nicely (for a GIS table)

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

Browse pgadmin-support by date

  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