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