Or this one:
http://schemaspy.sourceforge.net/
On Sep 8, 2007, at 4:43 AM, A. Kretschmer wrote:
> am Sat, dem 08.09.2007, um 11:44:17 +0200 mailte Thorsten Kraus
> folgendes:
>> Hello,
>>
>> I am looking for a tool which is able to generate a database diagramm
>> including the relationships from an existing database schema. The
>> only
>> tool I know for this purpose is the Clay database plugin for eclipse.
>> Are there any other tools which can help me?
>
> Maybe this one:
>
> postgresql-autodoc - utility to create system tables overview in
> HTML, DOT and XML
>
>
> ,----[ apt-cache show postgresql-autodoc ]
> | Description: utility to create system tables overview in HTML,
> DOT and XML
> | This is a utility which will run through PostgreSQL system
> tables and returns
> | HTML, DOT, and 2 styles of XML which describes the database.
> | .
> | The HTML is human readable (via webbrowser). The first style of
> XML is actually
> | the fileformat of Dia, a UML diagram tool. The second type of
> XML is similar to
> | the HTML but in the Docbook 4 format. It enables you to mix in
> other docbook
> | documentation via the XREFs, generating PDFs, HTML, RTF, or
> other formatted
> | documents. Between these tools and JavaDoc with the appropriate
> XREFs,
> | documentation about a project can be generated quickly and be
> easily updatable
> | yet have a very professional look with some DSSSL work.
> `----
>
> Andreas
> --
> Andreas Kretschmer
> Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
> GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq