Search Postgresql Archives

Re: tool for DB design

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I wrote a little LGPL app that generates Postgres SQL code from a graphical datamodel. It's not professional quality, but it functions. I don't actively maintain it, but I still use it for brainstorming datamodels and quick generation of the database.

http://www.hardgeus.com/projects/pgdesigner/



Tino Wildenhain wrote:

Nikolay Samokhvalov schrieb:

dbvis isn't the thing what I need. Or I'm blind and cannot find where
I can draw ER/UML diagram then transform it to physical, then obtain
SQL code. Or, just physical->SQL. Please correct me if I'm wrong.


Well, I mentioned DIA for this - reread my mail please ;)
I said DIA for ER -> SQL and dbvis for physical -> ER.
physical -> SQL is covered by pg_dump.

On 25/11/05, Tino Wildenhain <tino@xxxxxxxxxxxxx> wrote:

Am Freitag, den 25.11.2005, 02:25 +0300 schrieb Nikolay Samokhvalov:

Please, suggest any free/opensource tool for DB design under Linux. I
need following: ER (or UML)-diagram -> physical diagram -> SQL code (I
don't even dream about reverse transformation...) Quite good example
of such tool is Sybase PowerDesigner (which supports Postgres), but
AFAIK it runs only under win and costs $...


dia can do this and I guess a lot of other tools.
For the reverse check out db visualizer (dbvis)
http://www.minq.se/products/dbvis/

Which has a very nice ER-view.
(With autorouting, which many tools, even the $$$-ones
miss)

++Tino





--
Best regards,
Nikolay



---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux