From: H. Hall <hhall1001@reedyriver.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Catalog
Date: Thu, 24 Jul 2008 06:58:38 -0400
Message-ID: <4888605E.1080007@reedyriver.com> (raw)
In-Reply-To: <D337038284820142B2A3196D1BFE2B47D7F10B@spswchi6mail1.peak6.net>
References: <15aa6b3e0807230832q40bd093ev41cb4c84b87d3128@mail.gmail.com>
<D337038284820142B2A3196D1BFE2B47D7F10B@spswchi6mail1.peak6.net>
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@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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: hhall1001@reedyriver.com
Subject: Re: Catalog
In-Reply-To: <4888605E.1080007@reedyriver.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox