Visualization of existing PostgreSQL databases

In Luna Modeler, 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.

Since version 6.4 you can easily select a schema or multiple schemas for the reverse engineering.

When you are finished, click the Save Connection button.

Connection to PostgreSQL

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.

A list of postgreSQL database connections stored in Luna Modeler - database design tool for PostgreSQL

As a result, you will see an ER diagram for your database structure. If you reverse engineered multiple schemas, you might find it useful to enable the Display schema mode.

Display schema option in Luna Modeler - ERD creator for PostgreSQL

In the Professional edition of Luna Modeler, you can also split the main diagram to multiple sub-diagrams by schemas.

Add diagrams by Schemas

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.

Tips for multiple schema selection

  • If you select a schema that contains an object from another schema and the second schema is not in your selection, Luna Modeler will recommend which other schema should be added to the selection for reverse engineering.
  • If you reverse engineer a schema that has a column that uses a data type of an unknown structure, the data type will be automatically added among the Custom data types.

To keep the structure as correct as possible, expand the list of schemas accordingly.


Quick links

Download Buy Now!

Blog Categories
Blog by Platforms