Hi,

Gabriele I had the same problem when I switched from MySQL to PostgreSQL (although I was not so pleased with DB-Designer no support, not open source, bugs with average size models, ...).

I had a look around and I could not find anything satisfying (with the same criteria as you).

Eventually, I have choosen SQuirreL:
http://squirrel-sql.sourceforge.net/

This is not a design tool: this is a database tool. You can edit, modify etc all your db objects (tables, views, ...) with a lot of RDBMS.
However, it includes also a graphical tool where you can display and arrange your tables.

So the way I work is: I create the tables in some ways (pgAdmin, scripts, SQuirreL, ...) and then I use SQuirreL to draw a nice graphic of the database. Of course, it is not as good as using a desing tool, because you start from the physical level, but that's the best I could find for my needs. And considering I can type in comments that stays in the database (with COMMENT ON ... commands), I am quite happy with this.


Good luck and let us know what you have chosen,
L@u
The Computing Froggy

----- Message d'origine ----
De : Lee Keel <lee.keel@uai.com>
À : Gabriele <gabriele_palma@tin.it>; pgsql-general@postgresql.org
Envoyé le : Jeudi, 5 Juillet 2007, 17h08mn 46s
Objet : Re: [GENERAL] Design Tool

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailtogsql-general-
> owner@postgresql.org] On Behalf Of Gabriele
> Sent: Tuesday, July 03, 2007 2:43 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Design Tool
>
> I need a design tool to design my database.
>
> Back in past I used DBDesigner (free) but it is best suited to MySQL
> and i now use PostGreSQL and SQLite.
>
> The tool should have most of the following:
>
> Ability to create a rather complex and arbitrarily big scheme and
> produce automatically the SQL code for PostGreSQL and for SQLite.
>
> Some degree of automation with "logical to physical" procedures
> (automake entity for n:n relationship, foreign key automatically added
> and other time saving stuff).
>
> Ability to produce documentation in XML/HTML using the schema and
> designer's comments on tables and properties (best would be an html
> documentation or an xml schema easily convertible in an html
> documentation with some other tool i don't know).
>
> A few tools of pure graphical purpose (colored boxes/panels, labels)
> and an easy way to arrange tables, show or hide additional
> information, organize relationship (move his names, eventually hide
> them), and the ability to export the whole thing as an image.
>
> "Free" or "not so costly" license. If i use postgresql is also to save
> money, as you might expect. A one hundred dollars software might be my
> solution, a one thousand dollars is probably not.
>
> Ability to generate CRUD stored procedure automatically may be
> appreciated, but i belienve it's more than i need.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

We are currently using DeZign for Database. This is not a freeware tool,
but is VERY useful. I am not sure how much "not so costly" is, but I find
it very reasonable for the time it saves me. It does do Postgres and MANY
more database formats. You can find more information at
http://www.datanamic.com/dezign/index.html

Regards,
Lee Keel
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/





__________________________________________________ ___________________________
Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster