[postgis-users] Data modeling tool

[Alexander Von Luenen]

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.Toutant at 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.toutant at inspq.qc.ca 
http://www.inspq.qc.ca 
 




Martin Fafard <martin.fafard at geoprojection.com>@postgis.refractions.net

Envoyé par : postgis-users-bounces at postgis.refractions.net 
30/06/2009 11:09 AM
Veuillez répondre à
martin.fafard at geoprojection.com; Veuillez répondre à
PostGIS Users Discussion <postgis-users at postgis.refractions.net>


A
PostGIS Users Discussion <postgis-users at postgis.refractions.net>
cc

Objet
Re: [postgis-users] Data modeling tool








Hi Steve

pgAdminIII (pgadmin.org)

Martin F

Steve.Toutant at 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.toutant at inspq.qc.ca 
http://www.inspq.qc.ca 
 


_______________________________________________
postgis-users mailing list
postgis-users at 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 at postgis.refractions.net 
http://postgis.refractions.net/mailman/listinfo/postgis-users