How to visualize database tables in postgresql using pgAdmin?

Question

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.

@amphibient Any visualization; if I can generate ERD that's even better. — sheidaei, Aug 23 '13 at 16:07
I have found this answer http://stackoverflow.com/a/9694261/892535 I am using pgAdmin 1.16 but can't see database designer tool. — sheidaei, Aug 23 '13 at 16:22
There you go everything is explained here http://dba.stackexchange.com/questions/16993/how-to-view-data-in-pgadmin-iii — ulrich, Apr 05 '15 at 22:07

score 69 · Answer 1 · answered Jul 09 '21 at 13:19

69

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

answered Jul 09 '21 at 13:19

midi

3,128
5
30
47

4

not in Beta anymore, i mean is just 'Generate ERD now', worked fine, thanks! – antont Dec 09 '21 at 14:43

score 23 · Accepted Answer · edited Dec 20 '18 at 13:46

23

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.

edited Dec 20 '18 at 13:46

runejuhl

2,147
1
17
17

answered Aug 23 '13 at 17:31

sheidaei

9,842
20
63
86

score 21 · Answer 3 · edited Apr 20 '18 at 13:23

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.

edited Apr 20 '18 at 13:23

Loofer

6,841
9
61
102

answered Apr 04 '16 at 21:44

user2669758

227
2
3

20

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? – Mel Feb 01 '17 at 03:54
2

pgAdmin removed this feature in newer versions, sadly. – Pepper Paige Jan 07 '20 at 15:16
5

in pgAdmin 4 right click on database -> Generate ERD (Beta) – Max Jul 05 '21 at 09:37

score 6 · Answer 4 · answered Oct 19 '16 at 10:01

6

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

answered Oct 19 '16 at 10:01

karl

61
1
1

score 2 · Answer 5 · answered Aug 08 '20 at 20:42

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.

answered Aug 08 '20 at 20:42

Swatar Common

21
2

For big companys only: not "free of charge". – catch22 Dec 16 '22 at 21:00

How to visualize database tables in postgresql using pgAdmin?

5 Answers5