Create an ER diagram in pgAdmin

sql postgresql pgadmin
vdegenne picture vdegenne · Mar 13, 2012 · Viewed 82.7k times · Source

What would be the step by step walk-through for building a basic Entity-Relationship Diagram from pgAdmin?

Would there be some plugins for doing that in pgAdmin?

Note: I searched in the web but other than stumbling upon an exhausting list of softwares (most of them not freeware or out-of-date) I wind up here without a clue.

Note2: My request is not narrowed down to pgAdmin, let's say I can export my tables.

Answer

Erwin Brandstetter picture Erwin Brandstetter · Mar 14, 2012

Update

Sadly, the database designer is not released with the main release of pgAdmin after all. (At least the case for version 1.16 through 1.22.)

See discussion here and here and finally:

You need to use --enable-databasedesigner with ./configure to enable it. By default, it's disabled.

There are too many bugs and rough edges and not enough people interested to work on it.

pgAdmin had a GSoC project in 2011, in the course of which Luis Ochoa designed the new database designer - which can also reverse engineer ER diagrams from existing dbs. Unfortunately it wasn't ready for release with pgAdmin 1.14 (the current version). But it's in the repository for version 1.16 that will probably accompany the release of PostgreSQL 9.2.

See a video here.
Screenshot.
Blog post announcing it.

There are still some rough edges, but Luis Ochoa recently announced he is working on it.

Related questions

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 …

Read More
How restore postgreSQL dump file using pgAdmin?

I've a .dmp file. Want to restore the database from it. Using pgAdmin how can I do it?

Read More
how to get column size and type through my database in PostgreSQL

I've changed column length manually in my previous database. But after creating new database via HQL it's creating varchar(255) and I need to make it longer. I need to find which table's column should I change? I can find it …

Read More