High-quality ERD generator for PostgresQL under Linux?

database-design postgresql entity-relationship erd
Dave Jarvis picture Dave Jarvis · May 30, 2010 · Viewed 36.6k times · Source

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:

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

jhexp picture jhexp · Jan 18, 2013

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.

Related questions

Is there data visualisation tool for postgresql which is capable of displaying inter schema relations as well?

Operating system used is linux. I have tried Navicat and SQL Power Architect. They did display relations between tables in the same schema. I have some foreign key constraints which reference tables in a different schema. Am I missing something …

Read More
Grant all on a specific schema in the db to a group role in PostgreSQL

Using PostgreSQL 9.0, I have a group role called "staff" and would like to grant all (or certain) privileges to this role on tables in a particular schema. None of the following work GRANT ALL ON SCHEMA foo TO staff; GRANT …

Read More
Create unique constraint with null columns

I have a table with this layout: CREATE TABLE Favorites ( FavoriteId uuid NOT NULL PRIMARY KEY, UserId uuid NOT NULL, RecipeId uuid NOT NULL, MenuId uuid ) I want to create a unique constraint similar to this: ALTER TABLE Favorites ADD …

Read More