Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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
like image 289
Dave Jarvis Avatar asked May 30 '10 06:05

Dave Jarvis


People also ask

Can we create ER diagram in PostgreSQL?

As a Postgres ER diagram tool, Navicat has the essential features for modeling your conceptual, logical, and physical data models. You can create complex ER Diagrams in Navicat using one of three standard notations: Crow's Foot, UML, or IDEF1x.


2 Answers

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.

like image 190
jhexp Avatar answered Sep 24 '22 07:09

jhexp


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

like image 21
Subbu Avatar answered Sep 20 '22 07:09

Subbu