From: | "H(dot) Hall" <hhall1001(at)reedyriver(dot)com> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Catalog |
Date: | 2008-07-24 10:58:38 |
Message-ID: | 4888605E.1080007@reedyriver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Travis Smith wrote:
> There are tools that allow you to reverse engineer schemas.. or to generate ERD's .. visio comes to mind. It works on odbc 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(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Sergio Gabriel Rodriguez
> Sent: Wednesday, July 23, 2008 10:32 AM
> To: pgsql-admin(at)postgresql(dot)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(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Bovitz | 2008-07-24 15:00:00 | Upgrade clients when (major) upgrading server? |
Previous Message | Marc Fromm | 2008-07-23 22:48:29 | -O to remove owner |