[postgis-users] Enhancing visualisation in PgAdmin

[James Klassen]

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 <marco at boeringa.demon.nl> 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
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220109/cf7f4cc6/attachment.html>