Thread: Schema relationship diagram

Schema relationship diagram

From
RPK
Date:
Is there any feature in PGSQL to view the schema relationship diagram?
--
View this message in context: http://www.nabble.com/Schema-relationship-diagram-tf3619278.html#a10105662
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


Re: Schema relationship diagram

From
"A. Kretschmer"
Date:
am  Fri, dem 20.04.2007, um  9:22:21 -0700 mailte RPK folgendes:
>
> Is there any feature in PGSQL to view the schema relationship diagram?

You can use tools like postgresql-autodoc for this.

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

Re: Schema relationship diagram

From
RPK
Date:
Where I can find this?


am  Fri, dem 20.04.2007, um  9:22:21 -0700 mailte RPK folgendes:
> Is there any feature in PGSQL to view the schema relationship diagram?

You can use tools like postgresql-autodoc for this.

--
View this message in context: http://www.nabble.com/Schema-relationship-diagram-tf3619278.html#a10113513
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


Re: Schema relationship diagram

From
Andreas Kretschmer
Date:
RPK <rpk.general@gmail.com> schrieb:

>
> Where I can find this?

Do you mean postgresql-autodoc? Depends on your distribition, i have
Debian and can do a simple 'apt-get install postgresql-autodoc', if i
want to install this.

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."    (unknow)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

Re: Schema relationship diagram

From
RPK
Date:
>quote author='Andreas Kretschmer-2'>
> Depends on your distribition

I am using pgsql 8.2.3 on Windows XP. I think open source programs are all
better out for Debian like thing. They work horribly strange on Windows.
--
View this message in context: http://www.nabble.com/Schema-relationship-diagram-tf3619278.html#a10113884
Sent from the PostgreSQL - general mailing list archive at Nabble.com.