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

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 default
• 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

Answer 1

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.

Answer 2

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).