High-quality ERD generator for PostgresQL under Linux? [closed]

Closed. This question needs debugging details. It is not currently accepting answers.

---

Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem. This will help others answer the question.

Closed 5 years ago.

Improve this question

Background

MySQL Workbench can produce appealing and high-quality ERDs such as:

Research

What PostgreSQL ERD tools are available that meet the requirements? The following are unsuitable:

• dbVisualizer - Yellow squares.
• AquaFold - Yellow squares.
• SQL Developer - Coloured squares.
• Dia - Coloured squares.
• SQL Power Architect - Black and white squares.
• SchemaBank - Can't export to PNG; looks okay, nothing stellar.
• SchemaSpy - XML export makes it possible to write an XSL skin...
• Gliffy - Incompatible Flash version.
• Druid - No.

Requirements

Looking for an ERD tool:

• Visually stunning by defa开发者_JAVA百科ult
• Can reverse-engineer a PostgreSQL (or JDBC-compliant) database
• Runs on Linux (or under WINE)
• Export high-resolution PNG (or SVG)
• Free or Open Source

---

This is a little bit dated question, but for completeness. What about PgModeler? According to their github repo it's under GPL3. Schema creation works well.

---

DbSchema is a Visual Designer for Relational & NoSQL Databases. It can be evaluated 15 days for free. After that a paid License must be purchased.

It can be used to generate a ERD for Postgresql as well as other databases.

Downloading installer

Installers are available to download for various platforms (Linux, Windows and MacOS).

Installing and running DbSchema on Linux

To install run following commands in your shell:

wget https://dbschema.com/download/DbSchema_unix_8_2_5.tar.gz
tar xf DbSchema_unix_8_2_5.tar.gz
cd DbSchema
chmod +x DbSchema_unix_8_x_x.sh

To run DbSchema:

./DbSchema_unix_8_x_x.sh

Note: Dependent on the downloaded version (e.g. 8_2_5) the commands above may change (i.e. replace 8_x_x with downloaded 8_2_5).

---

You may try DbVisualizer. In my opinion, DbVisualizer in references graphs has met my needs in generating ERD from existing database.

---

What about SQL Power Architect? Works for many databases, PostgreSQL included, and on many operating systems.