[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] PGAdmin4 - not getting swamped by geometry columns in data view?
From: Gary Turner via postgis-users <postgis-users () lists ! osgeo ! org>
Date: 2023-10-19 22:30:07
Message-ID: 137a7a13-dfb0-4119-9752-174dd8198659 () elizr ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
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@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@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
[Attachment #5 (text/html)]
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Thanks Nicolas,</p>
<p>Although that wasn't quite what I wanted, as the column name is
typically very small, you did point me in the right direction.</p>
<p>Right under that, there's a 'Maximum column width', which worked
well when set to 200<br>
</p>
<div class="moz-cite-prefix">On 18/10/2023 9:42 pm, Nicolas Ribot
via postgis-users wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAGAwT=0jiB-FOmK6icf8vJyJSsPrACfD5jTPAnY7muBy1cDevA@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">Hello,
<div>You can choose the default columns size in PgAdmin
preferences. It defaults to "column data" but you can set it
to be "column name":</div>
<div>"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"</div>
<div><br>
</div>
<div>Go to preferences -> Query Tool -> Result Grid ->
Columns sized by...</div>
<div><br>
</div>
<div>Nicolas</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Wed, 18 Oct 2023 at 07:57,
Gary Turner via postgis-users <<a
href="mailto:postgis-users@lists.osgeo.org"
moz-do-not-send="true" \
class="moz-txt-link-freetext">postgis-users@lists.osgeo.org</a>> wrote:<br>
</div>
<blockquote class="gmail_quote"
style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex">Apologies in advance if this is a silly question, \
or this is an <br> inappropriate place to ask.<br>
<br>
I've recently switched from pgadmin3 to 4 on a new windows
machine, and <br>
I occasionally use it to look at metadata. The tables I use <br>
unfortunately tend to have the geometry columns at the left of
the table.<br>
<br>
In V3, the geometry was width limited. In 4 it's not, and I
can't even <br>
scroll past the geometry column to find the data that's to the
right of it.<br>
<br>
Is there a way to limit the width of the geometry column? Or
even hide it?<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank"
moz-do-not-send="true" \
class="moz-txt-link-freetext">postgis-users@lists.osgeo.org</a><br> <a
href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
rel="noreferrer" target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
</blockquote>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" \
wrap="">_______________________________________________ postgis-users mailing list
<a class="moz-txt-link-abbreviated" \
href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a> <a \
class="moz-txt-link-freetext" \
href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
</body>
</html>
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic