Can you recommend a PostgreSQL Visual Database Designer for Linux?

Question

When I'm in Windows, I use the excellent MicroOLAP Database Designer for PostgreSQL, but its not open source or multiplataform.
Do you know or can recommend me an alternative to this software, that I can use in Linux?

EDIT: Just to clarify, I don't want to use wine to emulate MicroOlap for PostgreSQL, it doesn't work too well, I would prefer something native, or Java based.

Maybe, limit products to open-source only – Kemin Zhou Dec 07 '16 at 23:16 — Kemin Zhou, Dec 07 '16 at 23:16

score 8 · Accepted Answer · answered Oct 01 '08 at 06:55

pgDesigner is a database design application for PostgreSQL, for versions 7.x and 8.x.

pgDesigner provides the following features:

Complete datamodel editor
Support for PostgreSQL objects: tables, views, relations, tablespaces, procedures, triggers, types, domains and sequences
Automatic updating of relations between tables.
Wizard for the construction of views.
Report generator, with statistics
Printing the diagram
SQL export
Creation of the database
Management of the project on a diagram chart

score 0 · Answer 2 · answered Sep 27 '08 at 21:18

0

I stopped using software database designers years ago, and reverted back to the trusty pen and paper which is just easier to use in my experience.

To answer your question though, take a look at dbDesigner4 which is what I used to use. I remember it being fantastic. It's open source and multiplatform.

answered Sep 27 '08 at 21:18

Andrew

1,216
10
17

1

dbDesigner4 looks like it's designed for MySQL, while @OP is looking for a designer for PostgreSQL. – John Millikin Sep 27 '08 at 21:20
1

That's right, dbDesigner4 is for MySQL, in fact, is the base for **MySQL Workbench**, but thanks for answer anyway. – Rodrigo Amaya Sep 27 '08 at 21:23

score 0 · Answer 3 · answered Sep 27 '08 at 21:31

0

How about Clay? It's a plugin for Eclipse, and the free version supports generating Postgres DDL.

answered Sep 27 '08 at 21:31

John Millikin

183,900
37
203
216

score 0 · Answer 4 · answered Sep 27 '08 at 21:34

0

I really like dbWrench. It's commercial as well, but not expensive and is Java based. It can reverse engineer a database and generates pretty good HTML based documentation.

http://www.dbwrench.com/

answered Sep 27 '08 at 21:34

Gavin M. Roy

4,025
4
32
28

score 0 · Answer 5 · answered Sep 28 '08 at 01:50

This is a crappy answer for which I should be taken out and shot, but you can search over nearly all PostgreSQL related projects at PgFoundry. I don't know from GUI database design tools, but I'd imagine you should be able to find something there, if it exists.

Can you recommend a PostgreSQL Visual Database Designer for Linux?

5 Answers5