Steve, there is a nice tool out there developed by MicroOLAP (http://www.microolap.com/), the Database Designer for PostgreSQL, which lets you draw ERM diagrams and then generates the database from that diagram. There's a free trial version on their webpage. This tool is also capable of reverse-engineering databases.
There is also a tool called PostGeoOLAP, but I haven't tried it yet. http://postgeoolap.projects.postgresql.org/ingles/release.html Cheers, Alex Dr Alexander von Luenen Senior Research Associate Great Britain Historical GIS Dept. of Geography University of Portsmouth Buckingham Building, Lion Terrace Portsmouth, PO1 3HE, UK tel: +44-(0)23-9284-2500 fax: +44-(0)23-9284-2512 >>> <steve.tout...@inspq.qc.ca> 30/06/2009 16:19 >>> Thanks Martin, I'm already using pgAdminIII to manually manage databases. What I meant is I need a tool to design a database structure (tables, fields, relations), so it can generate scripts to physically create the tables when the model is complete. I need this tools to make reverse engineering, generate documentation about a database, etc.... As far as I know pgAdmin doesn't do that. steve Steve Toutant, M. Sc. Analyste en géomatique Secteur environnement Direction des risques biologiques, environnementaux et occupationnels Institut national de santé publique du Québec 945, avenue Wolfe Québec, Qc G1V 5B3 Tél.: (418) 650-5115 #5281 Fax.: (418) 654-3144 steve.tout...@inspq.qc.ca http://www.inspq.qc.ca Martin Fafard <martin.faf...@geoprojection.com>@postgis.refractions.net Envoyé par : postgis-users-boun...@postgis.refractions.net 30/06/2009 11:09 AM Veuillez répondre à martin.faf...@geoprojection.com; Veuillez répondre à PostGIS Users Discussion <postgis-users@postgis.refractions.net> A PostGIS Users Discussion <postgis-users@postgis.refractions.net> cc Objet Re: [postgis-users] Data modeling tool Hi Steve pgAdminIII (pgadmin.org) Martin F steve.tout...@inspq.qc.ca a écrit : Hello, I searched for a data modeling/build/management tool for postresql and postgis. I would like to have the opinion of users, which one really works? Could be open source or commercial. Regards, Steve Steve Toutant, M. Sc. Analyste en géomatique Secteur environnement Direction des risques biologiques, environnementaux et occupationnels Institut national de santé publique du Québec 945, avenue Wolfe Québec, Qc G1V 5B3 Tél.: (418) 650-5115 #5281 Fax.: (418) 654-3144 steve.tout...@inspq.qc.ca http://www.inspq.qc.ca _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.375 / Virus Database: 270.13.0/2210 - Release Date: 06/30/09 06:10:00 _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
