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.
https://docs.qgis.org/latest/en/docs/user_manual/plugins/core_plugins/plugins_db_manager.html Alternatively, making views with pgAdmin and then loading the view in QGIS works. > On Jan 7, 2022, at 11:21, Marco Boeringa <[email protected]> wrote: > > 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. > > Marco > > Op 6-1-2022 om 22:37 schreef Shaozhong SHI: >> 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. >> >> Is this possible? >> >> Regards, >> >> David >> >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> https://lists.osgeo.org/mailman/listinfo/postgis-users > _______________________________________________ > postgis-users mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
