Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0AA70650040 for ; Thu, 24 Jul 2008 08:08:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 27805-07 for ; Thu, 24 Jul 2008 08:08:39 -0300 (ADT) X-Greylist: delayed 00:05:02.117355 by SQLgrey-1.7.6 Received: from fmailhost06.isp.att.net (fmailhost06.isp.att.net [204.127.217.106]) by postgresql.org (Postfix) with ESMTP id EF15D65001C for ; Thu, 24 Jul 2008 08:08:42 -0300 (ADT) Received: from [127.0.0.1] (adsl-155-175-176.gsp.bellsouth.net[72.155.175.176]) by isp.att.net (frfwmhc06) with ESMTP id <20080724105837H06009qv9de>; Thu, 24 Jul 2008 10:58:37 +0000 X-Originating-IP: [72.155.175.176] Message-ID: <4888605E.1080007@reedyriver.com> Date: Thu, 24 Jul 2008 06:58:38 -0400 From: "H. Hall" User-Agent: Thunderbird 2.0.0.14 (Windows/20080421) MIME-Version: 1.0 To: "pgsql-admin@postgresql.org" Subject: Re: Catalog References: <15aa6b3e0807230832q40bd093ev41cb4c84b87d3128@mail.gmail.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200807/205 X-Sequence-Number: 29815 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