Tools to generate database tables diagram with PostgreSQL? [closed]

Question

Closed. This question is seeking recommendations for software libraries, tutorials, tools, books, or other off-site resources. It does not meet Stack Overflow guidelines. It is not currently accepting answers.

We don’t allow questions seeking recommendations for software libraries, tutorials, tools, books, or other off-site resources. You can edit the question so it can be answered with facts and citations.

Closed 10 years ago.

Improve this question

Are there any free tools to generate table diagrams with PostgreSQL?

Since this question got closed, I asked on the software recommendation SE: Generate database table diagrams from a PostgreSQL database — Franck Dernoncourt
– Franck Dernoncourt, Commented Jul 9, 2016 at 21:46
Would be better and helpful to add a suggestion on what appropriate site under Stack Exchange communities to ask. — Jeb50
– Jeb50, Commented Jun 7, 2021 at 18:47
In one word, dbeaver. Works out of the box. Also, you can refer to wiki.postgresql.org/wiki/Design_Tools — ivorynoise
– ivorynoise, Commented Apr 20, 2022 at 12:58
One great solution would be using intellij idea / datagrip's: Right-click on the database's table name > Diagram > Show Visualization -> Some icon in the top for Export Diagram > Open in Web Editor > (Choose whichever you like more) — forhadmethun
– forhadmethun, Commented Oct 27, 2022 at 23:42

sunapi386 · Accepted Answer · 2022-12-19 07:39:56Z

221

I love schemaspy for schema visualisations. Look at the sample output they provide, and drool. Note the tabs!

You'll need to download the JDBC driver here, then your command should look something like:

java -jar schemaspy-6.0.0-rc2.jar -t pgsql -db database_name -host myhost -u username -p password -o ./schemaspy -dp postgresql-9.3-1100.jdbc3.jar -s public -noads

Sometimes using options -port will not working if your database has diferrent port, so you have to add manual port after host parameter, for example:

java -jar schemaspy-6.0.0-rc2.jar -t pgsql -db database_name -host myhost:myport -u username -p password -o ./schemaspy -dp postgresql-9.3-1100.jdbc3.jar -s public -noads

You'll need to install graphviz as well if you want graphics (apt-get install graphviz for debian based distros).

edited Dec 19, 2022 at 7:39

sunapi386

1,38716 silver badges19 bronze badges

answered Jul 13, 2010 at 13:40

Jurgen

2,2431 gold badge12 silver badges3 bronze badges

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

14 Comments

visionary Over a year ago

Actually it's graphviz :)

pretzels1337 Over a year ago

Schemaspy did this trick on first try. Layout of generate graph was great (even on our complex table set). When 100 tables reference the same table there will be overlapping lines; however the overall layout compensates for this and is perfectly legible/traceable.

AzizSM Over a year ago

for graphviz just append the -gv /path_to/graphviz to the command

slashdottir Over a year ago

On mac I had to add: -renderer :quartz to avoid this error: -Tcmapx' failed with return code 139

a-h Over a year ago

To run this using Docker on the mac:

docker run -v `pwd`/diagram:/output schemaspy/schemaspy:snapshot -t pgsql --port 5432 -u postgres -db <dbname> -host docker.for.mac.localhost -p <password>

|

Sualeh Fatehi · Accepted Answer · 2018-01-26 00:18:27Z

33

SchemaCrawler for PostgreSQL can generate database diagrams from the command line, with the help of GraphViz. You can use regular expressions to include and exclude tables and columns. It can also infer relationships between tables using common naming conventions, if not foreign keys are defined.

edited Jan 26, 2018 at 0:18

answered Jul 13, 2010 at 16:05

Sualeh Fatehi

4,7822 gold badges26 silver badges29 bronze badges

Comments

Zane · Accepted Answer · 2013-08-22 00:42:29Z

20

Quick solution I found was inside the pgAdmin program for windows. Under Tools menu there is a "Query Tool". Inside the Query Tool there is a Graphical Query Builder that can quickly show the database tables details. Good for a basic view

answered Aug 22, 2013 at 0:42

Zane

5601 gold badge5 silver badges15 bronze badges

4 Comments

pyb Over a year ago

I can't see how to automatically draw relationships using foreign keys in pgAdmin 1.20.0. Is it supported?

Andrew Swan Over a year ago

Nice tip, although it seems you have to draw all the FKs yourself using query joins.

Noumenon Over a year ago

This feature was removed in PgAdmin 4 in 2016. It might be reimplemented but has not been as of 2019.

Steve Chambers Over a year ago

See this answer for how to generate an ERD in pgAdmin 4 version 30 or higher.

Frank Heikens · Accepted Answer · 2010-07-12 05:51:01Z

14

Check the wiki: http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools

answered Jul 12, 2010 at 5:51

Frank Heikens

129k26 gold badges157 silver badges153 bronze badges

Comments

Taylored Web Sites · Accepted Answer · 2012-07-04 21:01:14Z

9

Just found http://www.sqlpower.ca/page/architect through the Postgres Community Guide mentioned by Frank Heikens. It can easily generate a diagram, and then lets you adjust the connectors!

answered Jul 4, 2012 at 21:01

Taylored Web Sites

1,0471 gold badge10 silver badges16 bronze badges

1 Comment

FuriousFolder Over a year ago

I couldn't get this to work; kept getting ArrayIndexOutOfBoundException

Faheem Mitha · Accepted Answer · 2018-03-11 17:56:01Z

7

PostgreSQL Autodoc has worked well for me. It is a simple command line tool. From the web page:

This is a utility which will run through PostgreSQL system tables and returns HTML, Dot, Dia and DocBook XML which describes the database.

edited Mar 11, 2018 at 17:56

answered Dec 22, 2013 at 23:23

Faheem Mitha

6,3768 gold badges51 silver badges85 bronze badges

5 Comments

nelsonic Over a year ago

Link in answer is broken. Googled and found: github.com/cbbrowne/autodoc but seems to be unmaintained.

Faheem Mitha Over a year ago

@nelsonic Indeed. Should I swap the links, or not? It doesn't seem to be by the same person who was maintaining it. Some kind of fork, it looks like.

nelsonic Over a year ago

I've asked the author on GitHub if the project is being maintained: github.com/cbbrowne/autodoc/issues/2

Faheem Mitha Over a year ago

@nelsonic Yes, I saw the reply. I also posted bugs.debian.org/820208

Kris Over a year ago

You can create a png from the dot file as such: dot -Tpng my_database.dot -o my_database.png.

leonbloy · Accepted Answer · 2010-07-12 15:33:16Z

2

Inside Eclipse I've used the Clay plugin (ex Clay-Azurri). The free version allows to introspect ("reverse engineer") an existing DB schema (via JDBC) and make a diagram of some selected tables.

answered Jul 12, 2010 at 15:33

leonbloy

76.4k22 gold badges149 silver badges197 bronze badges

Collectives™ on Stack Overflow

Tools to generate database tables diagram with PostgreSQL? [closed]

7 Answers 7

14 Comments

Comments

4 Comments

Comments

1 Comment

5 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

14 Comments

Comments

4 Comments

Comments

1 Comment

5 Comments

Comments

Linked

Related