How to visualize database tables in postgresql using pgAdmin?

sql database postgresql pgadmin
sheidaei picture sheidaei · Aug 23, 2013 · Viewed 86.7k times · Source

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.

Answer

user2669758 picture user2669758 · Apr 4, 2016

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 questions

How to grant all privileges on views to arbitrary user

How do you grant read/select access on all functions and views to an arbitrary user? I use psql --user=postgres -d mydb -f myview.sql to create several functions and views, and then I run: GRANT ALL PRIVILEGES ON …

Read More
How can I send email from PostgreSQL trigger?

I using pgsql to set a trigger, when update the table dataset(change the status to Finished) it will automatic send a email to the email account using dataset email value and save this email in server but i don't …

Read More
How to select the nth row in a SQL database table?

I'm interested in learning some (ideally) database agnostic ways of selecting the nth row from a database table. It would also be interesting to see how this can be achieved using the native functionality of the following databases: SQL Server …

Read More