Create an ER diagram in pgAdmin [closed]

Question

Please provide a step-by-step answer on how to build a basic Entity-Relationship Diagram (ERD) using the admin tool that comes with postgres (pgAdmin) with the the database designer that comes with postgres.

Note that the general question on what is the best way to generate a diagram from postgres, is addressed in this softwarerecs.stackexchange question

Answer 1

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.

Answer 2

If you are running Linux, you could use pgDesigner: http://sourceforge.net/projects/pgdesigner/