<!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>