Re: Catalog

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

In response to

Browse pgsql-admin by date

  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