Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to visualize database tables in postgresql using pgAdmin?

I am trying to visualize tables and their relations using pgAdmin. I have understood that there is a query visualizer tool available for pgAdmin. However, that only is useful if you are dealing with queries. My main goal is to generate a graphical representation of all the tables available in database.

like image 569
sheidaei Avatar asked Aug 23 '13 15:08

sheidaei


People also ask

How do I view the table in PgAdmin 4?

To view or modify data, right click on a table or view name in the Browser tree control. When the context menu opens, use the View/Edit Data menu to specify the number of rows you would like to display in the editor panel. To modify the content of a table, each row in the table must be uniquely identifiable.


1 Answers

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

enter image description here

like image 75
midi Avatar answered Sep 28 '22 21:09

midi