Re: [pgadmin-support] postgis geometry type not displayed correctly

From: Richard Greenwood <richard(dot)greenwood(at)gmail(dot)com>
To: Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com>
Cc: Dave Page <dpage(at)pgadmin(dot)org>, pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: [pgadmin-support] postgis geometry type not displayed correctly
Date: 2017-07-17 23:43:42
Message-ID: CAHBySPaKaGmaKquvbXFkpPK5PnrYtghmGCs3Rq3fJq4tEvwB4A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

In 1.6 a PostGIS geometry column now shows as "Geometry" in both the
Table>SQL tab and the Column>SQL tab. Thanks for that. But in psql and
pgAdmin3 it would be shown as e.g. "MultiPolygon, 3739". It would be very
helpful if pgAdmin4 could also show that level of detail.

Thanks,
Rich

On Tue, May 30, 2017 at 11:57 PM, Khushboo Vashi <
khushboo(dot)vashi(at)enterprisedb(dot)com> wrote:

>
> On Tue, May 30, 2017 at 8:51 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>
>> Khushboo, can you look into this please (and log and RM to go with it
>> if required)?
>>
>> Sure, I will work on this after finishing my current RM #2425
> <https://redmine.postgresql.org/issues/2425> .
>
>> Thanks.
>>
>> On Tue, May 30, 2017 at 4:09 PM, Richard Greenwood
>> <richard(dot)greenwood(at)gmail(dot)com> wrote:
>> > I don't know if this question belongs on this list or the postgis list.
>> In
>> > psql and pgAdmin3 a postgis geometry column is show as e.g.
>> >
>> > Column | Type
>> > ---------------+---------------------
>> > polygeom | geometry(MultiPolygon,3739)
>> >
>> > however in pgAdmin4 it's show as:
>> >
>> > polygeom geometry(957204)
>> >
>> > Like "957204" is not being translated to "MultiPolygon, 3739". Any
>> ideas or
>> > should I be asking this on the postgis list?
>> >
>> > Thanks,
>> > Rich
>> >
>> > --
>> > Richard W. Greenwood, PLS
>> > www.greenwoodmap.com
>>
>>
>>
>> --
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>
>

--
Richard W. Greenwood, PLS
www.greenwoodmap.com

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Khushboo Vashi 2017-07-18 03:43:07 Re: [pgadmin-support] postgis geometry type not displayed correctly
Previous Message Scott McIntosh 2017-07-17 22:18:18 FW: Troubles creating job schedule