Travis Smith wrote:
> There are tools that allow you to reverse engineer schemas.. or to generate ERD's .. visio comes to mind. It works
onodbc connections.
>
>
>
Schema Spy is a slick tool and is free. Works well with postgres. You
can find it at source forge:
http://schemaspy.sourceforge.net/
Here is their description:
Graphical Database Schema Metadata Browser
SchemaSpy is a Java-based tool (requires Java 1.4 or higher) that
analyzes the metadata of a schema in a database and generates a visual
representation of it in a browser-displayable format. It lets you click
through the hierarchy of database tables via child and parent table
relationships. The browsing through relationships can occur though HTML
links and/or though the graphical representation of the relationships.
It's also designed to help resolve the obtuse errors that a database
sometimes gives related to failures due to constraints.
Cheers,
HH
> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Sergio Gabriel
Rodriguez
> Sent: Wednesday, July 23, 2008 10:32 AM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] Catalog
>
> Hi for all,
> is possible to get PostgreSQL Catalog EER diagram? where can I get it?
>
> regards
>
> Sergio Gabriel Rodriguez
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
> _______________________________________________________
>
> The information in this email or in any file attached
> hereto is intended only for the personal and confiden-
> tial use of the individual or entity to which it is
> addressed and may contain information that is propri-
> etary and confidential. If you are not the intended
> recipient of this message you are hereby notified that
> any review, dissemination, distribution or copying of
> this message is strictly prohibited. This communica-
> tion is for information purposes only and should not
> be regarded as an offer to sell or as a solicitation
> of an offer to buy any financial product. Email trans-
> mission cannot be guaranteed to be secure or error-
> free. P6070214
>
>
--
H. Hall
ReedyRiver Group LLC
http://www.reedyriver.com