Reverse engineering and visualization of PostgreSQL databases

 

Note: this page is outdated. Please visit  Visualization of existing PostgreSQL databases

 

Creating ER diagram from PostgreSQL

All database connections are available in the Connections section. To create a new connection, click the Connections button on the main toolbar, and then click Create New Connection. A new modal form opens. Select PostgreSQL and enter the connection details.

When you are finished, click the Save Connection button.

Reverse engineering of PostgreSQL database structure

Your new PostgreSQL connection will appear in the list of all database connections.

To start the reverse engineering process, click Connect and load the existing database connection.

Connect and load

As a result, you will see an ER diagram for your database structure.

If you wish to visualize another PostgreSQL database, either create a new connection or create a copy of an existing connection by clicking the Duplicate link.

#