[postgis-users] PGAdmin4 - not getting swamped by geometry columns in data view?

Kobben, Barend (UT-ITC) b.j.kobben at utwente.nl
Wed Oct 18 04:12:10 PDT 2023


in addition, Pgadmin4 also shows a map preview of geo-data, click the little map icon in the column header

--
Barend Köbben


On 18/10/2023, 10:42, "postgis-users" <postgis-users-bounces at lists.osgeo.org> wrote:

Hello,
You can choose the default columns size in PgAdmin preferences. It defaults to "column data" but you can set it to be "column name":
"If set to 'Column data' columns will auto-size to the maximum width of the data in the column as loaded in the first batch. If set to 'Column name', the column will be sized to the widest of the data type or column name"

Go to preferences -> Query Tool -> Result Grid -> Columns sized by...

Nicolas

On Wed, 18 Oct 2023 at 07:57, Gary Turner via postgis-users <postgis-users at lists.osgeo.org<mailto:postgis-users at lists.osgeo.org>> wrote:
Apologies in advance if this is a silly question, or this is an
inappropriate place to ask.

I've recently switched from pgadmin3 to 4 on a new windows machine, and
I occasionally use it to look at metadata. The tables I use
unfortunately tend to have the geometry columns at the left of the table.

In V3, the geometry was width limited. In 4 it's not, and I can't even
scroll past the geometry column to find the data that's to the right of it.

Is there a way to limit the width of the geometry column? Or even hide it?

_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org<mailto:postgis-users at lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20231018/fb3ab88c/attachment.htm>


More information about the postgis-users mailing list