<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div dir="ltr"></div><div dir="ltr">Also, the DB Manager in QGIS is very useful for composing SQL queries on the fly and then adding the results as a map layers. And once happy with the query it can be “saved” to the database as a view.</div><div dir="ltr"><br></div><div dir="ltr"><a href="https://docs.qgis.org/latest/en/docs/user_manual/plugins/core_plugins/plugins_db_manager.html">https://docs.qgis.org/latest/en/docs/user_manual/plugins/core_plugins/plugins_db_manager.html</a></div><div dir="ltr"><br></div><div dir="ltr">Alternatively, making views with pgAdmin and then loading the view in QGIS works.</div><div dir="ltr"><br><blockquote type="cite">On Jan 7, 2022, at 11:21, Marco Boeringa <marco@boeringa.demon.nl> wrote:<br><br></blockquote></div><blockquote type="cite"><div dir="ltr"><span>pgAdmin is not supposed to a be a full fledged GIS, it is an administrative tool to manage your (spatial) databases, that just happens to have some very rudimentary spatial visualization capability. If you need GIS type symbolization and labelling functionality, install QGIS, it has everything you can desire in that respect.</span><br><span></span><br><span>Marco</span><br><span></span><br><span>Op 6-1-2022 om 22:37 schreef Shaozhong SHI:</span><br><blockquote type="cite"><span>The standard visualisation in PgAdmin is rather limited. Is there anyway to enhance visualisation in PgAdmin. For instance, mark a start_node as 6A and its end_node as 6B so that we can visualise definitions of nodes, segments/links and direction of travel in a network.</span><br></blockquote><blockquote type="cite"><span></span><br></blockquote><blockquote type="cite"><span>Is this possible?</span><br></blockquote><blockquote type="cite"><span></span><br></blockquote><blockquote type="cite"><span>Regards,</span><br></blockquote><blockquote type="cite"><span></span><br></blockquote><blockquote type="cite"><span>David</span><br></blockquote><blockquote type="cite"><span></span><br></blockquote><blockquote type="cite"><span>_______________________________________________</span><br></blockquote><blockquote type="cite"><span>postgis-users mailing list</span><br></blockquote><blockquote type="cite"><span>postgis-users@lists.osgeo.org</span><br></blockquote><blockquote type="cite"><span>https://lists.osgeo.org/mailman/listinfo/postgis-users</span><br></blockquote><span>_______________________________________________</span><br><span>postgis-users mailing list</span><br><span>postgis-users@lists.osgeo.org</span><br><span>https://lists.osgeo.org/mailman/listinfo/postgis-users</span><br></div></blockquote></body></html>