103

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.

Improve this question
6
  • are you trying to extract an ERD ? Commented Aug 23, 2013 at 15:56
  • @amphibient Any visualization; if I can generate ERD that's even better. Commented Aug 23, 2013 at 16:07
  • can you use Visio for that, if you have it ? Commented Aug 23, 2013 at 16:20
  • or this smartdraw.com/specials/erddataflow.asp Commented Aug 23, 2013 at 16:21
  • I have found this answer stackoverflow.com/a/9694261/892535 I am using pgAdmin 1.16 but can't see database designer tool. Commented Aug 23, 2013 at 16:22

6 Answers 6

Reset to default
115

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

enter image description here

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

not in Beta anymore, i mean is just 'Generate ERD now', worked fine, thanks!
How to do this for just an individual table and its relatives?
25

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.

Improve this answer

Comments

21

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.

Improve this answer

3 Comments

Hello, where is the tab for the Graphical Query Builder? I have the query tool, but then the options within it are no tabs gall GQB. Where can i find this tool?
pgAdmin removed this feature in newer versions, sadly.
in pgAdmin 4 right click on database -> Generate ERD (Beta)
6

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

Improve this answer

Comments

2

You can use JetBrains DataGrip for visualize your database schemas. Create a connection to DB, and right click on [shema name] -> Diagrams -> Show visualisation.

Improve this answer

1 Comment

For big companys only: not "free of charge".
1

You can simply right click on the database and select Query Tool and then right the query for select the needed table columns query to display.

E.g.,

select *
from product

enter image description here

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.