I tried a lot of apps. The one I prefer is "DbDesigner4" but I don't see support for postgresql... Only Oracle, mySQL...
There is support for ODBC, I don't know if that will do the job if I install Unix-ODBC and create a postgres data source. The point is, IF I succeed to make it work with postgres, I don't know if I will have a non-optimized database at the end... because DBDesigner4 won't take profit of postgres features? On Sun, 2004-11-07 at 00:29, Alvaro Herrera Munoz wrote: > On Sat, Nov 06, 2004 at 10:32:30PM -0500, Eric wrote: > > Is there a visual designer (open source) in linux for database? I would > > like to developp my data model on the computer... > > > > I see "dia" with uml library but... it won't export to SQL. > > You can have UML diagrams exported to SQL with some Perl or Python program > whose URL you can find on Dia's homepage. dia2sql or something like > that. It's damn easy. Hmm ... I think I got the URL somewhere ... > yes, you are lucky: http://tedia2sql.tigris.org/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
