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

Gary Turner g at elizr.com
Thu Oct 19 15:30:07 PDT 2023


Thanks Nicolas,

Although that wasn't quite what I wanted, as the column name is 
typically very small, you did point me in the right direction.

Right under that, there's a 'Maximum column width', which worked well 
when set to 200

On 18/10/2023 9:42 pm, Nicolas Ribot via postgis-users 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> 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
>     https://lists.osgeo.org/mailman/listinfo/postgis-users
>
>
> _______________________________________________
> postgis-users mailing list
> 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/20231020/5c87cb75/attachment.htm>


More information about the postgis-users mailing list