<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<font face="Helvetica, Arial, sans-serif">Yet another reason to
install QGIS is that it will read just about any GIS data format;
the layer can then be saved as a shapefile which can be imported
into PostGIS using the PostGIS Shapefile import tool. <br>
<br>
Ruven Brooks<br>
</font><br>
<div class="moz-cite-prefix">On 3/8/2022 9:59 PM, Brent Wood wrote:<br>
</div>
<blockquote type="cite"
cite="mid:2051803753.505461.1646798378303@mail.yahoo.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div class="ydpd8a1ae2fyahoo-style-wrap"
style="font-family:verdana, helvetica,
sans-serif;font-size:16px;">
<div dir="ltr" data-setdir="false">I'd also look as DBeaver, it
has a free Community Edition and a nice (but basic) geometry
viewer for Postgis. Built in support for a good set of
backgrounds as well. Postgis columns are auto displayed as WKT
which I find useful. <br>
</div>
<div dir="ltr" data-setdir="false"><br>
</div>
<div dir="ltr" data-setdir="false">For a user (vs admin) of a
Postgis DB I think DBeaver is nicer than PgAdmin. It does
primitive ERD's, which I don't think PgAdmin can do yet, but
that might have changed since I last looked...</div>
<div dir="ltr" data-setdir="false"><br>
</div>
<div dir="ltr" data-setdir="false">And you can access many other
databases than just Postgres.<br>
</div>
<div><br>
</div>
<div dir="ltr" data-setdir="false">But I agree with Ruven, if
you want to do more that a casual perusal of Postgis data, go
QGIS.<br>
</div>
<div><br>
</div>
<div><br>
</div>
<div dir="ltr" data-setdir="false">Brent Wood<br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
<div id="ydp88b1ee0cyahoo_quoted_6986965621"
class="ydp88b1ee0cyahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial,
sans-serif;font-size:13px;color:#26282a;">
<div> On Wednesday, March 9, 2022, 03:41:01 PM GMT+13,
<a class="moz-txt-link-abbreviated" href="mailto:ruvenml@beamerbrooks.com">ruvenml@beamerbrooks.com</a> <a class="moz-txt-link-rfc2396E" href="mailto:ruvenml@beamerbrooks.com"><ruvenml@beamerbrooks.com></a>
wrote: </div>
<div><br>
</div>
<div><br>
</div>
<div>
<div id="ydp88b1ee0cyiv1205987156">
<div> <font face="Helvetica, Arial, sans-serif">Out of
idle curiosity, I looked at Geometry Viewer. It
allows just one data display layer so you can only
look at one table/query at a time. The style of the
geometric objects is hard coded so you can't change
their color, background pattern, line style etc. It
does not support color scales. I can't think of any
use case for which it would be useful.<br clear="none">
<br clear="none">
I would strongly suggest using QGIS instead. Not only
does QGIS have all of the capabilities missing from
Geometry Viewer but it will read directly from PostGIS
tables. Since it's so widely used there's lots of
documentation and other learning materials; I counted
five different Youtube beginner's tutorials. <br
clear="none">
<br clear="none">
Ruven Brooks<br clear="none">
<br clear="none">
</font><br clear="none">
<br clear="none">
<div id="ydp88b1ee0cyiv1205987156yqt82605"
class="ydp88b1ee0cyiv1205987156yqt6465478231">
<div class="ydp88b1ee0cyiv1205987156moz-cite-prefix">On
3/8/2022 5:02 AM, Shaozhong SHI wrote:<br
clear="none">
</div>
<blockquote type="cite"> </blockquote>
</div>
</div>
<div id="ydp88b1ee0cyiv1205987156yqt48428"
class="ydp88b1ee0cyiv1205987156yqt6465478231">
<div>
<div dir="ltr">Sometime, when clicking on the eye
button in PgAdmin, Geometry Viewer gets into a mode
to display background map with options like Empty,
Street, Topography, Grey Scale, Light Colour and
Dark Matter.
<div><br clear="none">
</div>
<div>I am interested in making use of visualisation
within PgAmin.</div>
<div><br clear="none">
</div>
<div>Are there any documentation or guides on how to
make the best use of these in PgAdmin?</div>
<div><br clear="none">
</div>
<div>Regards,</div>
<div><br clear="none">
</div>
<div>David</div>
</div>
<br clear="none">
<fieldset
class="ydp88b1ee0cyiv1205987156moz-mime-attachment-header"></fieldset>
<pre class="ydp88b1ee0cyiv1205987156moz-quote-pre">_______________________________________________
postgis-users mailing list
<a shape="rect" href="mailto:postgis-users@lists.osgeo.org" class="ydp88b1ee0cyiv1205987156moz-txt-link-abbreviated moz-txt-link-freetext" rel="nofollow" target="_blank" moz-do-not-send="true">postgis-users@lists.osgeo.org</a>
<a shape="rect" href="https://lists.osgeo.org/mailman/listinfo/postgis-users" class="ydp88b1ee0cyiv1205987156moz-txt-link-freetext moz-txt-link-freetext" rel="nofollow" target="_blank" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a>
</pre>
<br clear="none">
</div>
</div>
</div>
<div class="ydp88b1ee0cyqt6465478231"
id="ydp88b1ee0cyqt52158">_______________________________________________<br
clear="none">
postgis-users mailing list<br clear="none">
<a shape="rect"
href="mailto:postgis-users@lists.osgeo.org"
rel="nofollow" target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">postgis-users@lists.osgeo.org</a><br
clear="none">
<a shape="rect"
href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
rel="nofollow" target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br
clear="none">
</div>
</div>
</div>
</div>
</blockquote>
<br>
</body>
</html>