<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7600.16588">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV dir=ltr align=left><SPAN class=956193018-04072010><FONT color=#0000ff
size=2 face=Arial>Jo,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=956193018-04072010><FONT color=#0000ff
size=2 face=Arial>We came across this one recently. Mostly just looking
for free tool with a nice ER Diagrammer with print functionality and export to
image etc and this one seemed to generate nice ER diagrams for PostgreSQL
from the table foreign key constraints that you can export as blown up png
image or svg format (we usually just print to a pdf printer). Haven't
tried its other features or on large databases yet though.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=956193018-04072010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=956193018-04072010><FONT color=#0000ff
size=2 face=Arial>You just register the JDBC driver like you do with any other
database. We were using the PostgreSQL 8.4 JDBC 4 driver with it. <A
href="http://jdbc.postgresql.org/download.html">http://jdbc.postgresql.org/download.html</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=956193018-04072010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=956193018-04072010><FONT color=#0000ff
size=2 face=Arial><A
href="http://sqldeveloper.solyp.com/screenshots/index.html">http://sqldeveloper.solyp.com/screenshots/index.html</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=956193018-04072010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=956193018-04072010><FONT color=#0000ff
size=2 face=Arial>Leo and Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=956193018-04072010><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>jj.wag@gmx.de<BR><B>Sent:</B> Friday, July 02, 2010 5:58 AM<BR><B>To:</B>
PostGIS Users Discussion<BR><B>Subject:</B> [postgis-users] db documentation
software<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>Hi,<BR>I'm working on a complex PostgreSQL / Postgis-Database with > 200
tables.<BR>At this time there is no good documentation for the database so
I'm<BR>searching for a OpenSource / cheap database-documentation software that
<BR>creates the table/field structure and relations/ERdiagram to a open format
<BR>(e.g. html).<BR>Any hints?<BR>Thanks<BR>Jo </DIV></BODY></HTML>