Can you recommend a PostgreSQL Visual Database Designer for Linux?

linux database-design postgresql olap
Rodrigo Amaya picture Rodrigo Amaya · Sep 27, 2008 · Viewed 14k times · Source

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.

Answer

Oli picture Oli · Oct 1, 2008

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

Related questions

How do I find all files containing specific text on Linux?

I'm trying to find a way to scan my entire Linux system for all files containing a specific string of text. Just to clarify, I'm looking for text within the file, not in the file name. When I was looking …

Read More
How to change permissions for a folder and its subfolders/files in one step?

I would like to change permissions of a folder and all its sub folders and files in one step (command) in Linux. I have already tried the below command but it works only for the mentioned folder: chmod 775 /opt/lampp/…

Read More
How can I recursively find all files in current and subfolders based on wildcard matching?

How can I recursively find all files in current and subfolders based on wildcard matching?

Read More