How to visualize database tables in postgresql using pgAdmin?

try pgModeler - there is working demo (although limited by number of objects). Also only PostgreSQL 9.x is supported.

I have found this webpage on postgresql wiki, with various tools on utilizing a postgresql database. I have used DbWrench on Mac to generate the ERD.

In pgAdmin 4 right click on the database and then "Generate ERD (Beta)"

enter image description here

For pgadmin 3 Go to Tools -> Query Tool

Graphical Query Builder is a tab in the Query Tool view.

unfortunately Pgadmin 4 does not have this option.

Related