Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 85362475F54 for ; Wed, 30 Oct 2002 19:12:45 -0500 (EST) Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id 25D2C474E5C for ; Wed, 30 Oct 2002 19:12:45 -0500 (EST) Received: by news.hub.org (Postfix, from userid 8) id EFD54381C30; Wed, 30 Oct 2002 19:12:43 -0500 (EST) From: Reinoud van Leeuwen X-Newsgroups: comp.databases.postgresql.sql Subject: Re: Database Design tool Date: Thu, 31 Oct 2002 01:12:27 +0100 Organization: Not organized in any way Reply-To: reinoud.v@n.leeuwen.net Message-ID: References: <1035988531.16497.1.camel@chello213047228041.tirol.surfer.at> X-Newsreader: Forte Agent 1.92/32.572 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 29 To: pgsql-sql@postgresql.org X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/12 X-Sequence-Number: 10154 On Wed, 30 Oct 2002 14:35:23 +0000 (UTC), johannes.lochmann@chello.at (Johannes Lochmann) wrote: >> Can anybody take me reference on Database design tool with PostgreSQL >> support. You can use PowerDesigner from Sybase. Windows only. A fully functional trial version (45 days) is downloadable at www.sybase.com. it has: - support for al major databases (Postgresql, Sybase, Oracle, MS SQL, Mysql) - support to generate triggers automatically - nice reporting features - ability to reverse engineer existing databases (through ODBC of from a file) - central repository (database) storage, or storage of your model in an XML file (which I use to auto generate perl classes from my saved model) - UML modeling - lots of other buzzword-compliant features ";-) It is an expensive tool, but if you do serious design work, you'll need a tool like this -- __________________________________________________ "Nothing is as subjective as reality" Reinoud van Leeuwen reinoud.v@n.leeuwen.net http://www.xs4all.nl/~reinoud