pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ray Ontko <rayo@ontko.com>
To: Renney Thomas <renneyt@yahoo.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: E-R Tool
Date: Mon, 7 Jun 2004 17:05:20 -0500
Message-ID: <20040607220520.GT23845@ontko.com> (raw)
In-Reply-To: <40C164A6.80708@yahoo.com>
References: <20040531211523.46183.qmail@web14101.mail.yahoo.com>
	<40BC7107.2040703@trade-india.com>
	<40C164A6.80708@yahoo.com>

Renney,

We've recently begun using Mogwai:

  http://mogwai.sourceforge.net/erdesigner/erdesigner.html

It's a lot like ERwin, but is open source and written in Java, so
it runs almost anywhere.  We run it under Windows and Linux.  I
assume that it will reverse engineer any foreign key constraints
that are defined in postgresql.  In our application, we don't
enforce the constraints so we didn't pick these up from the
database.  Instead, we drew the relationship lines between the
entities after picking up the tables from postrgresql.  It
figured out the crows-feet part from there.

Hope this helps.

Ray

On Sat, Jun 05, 2004 at 02:13:58AM -0400, Renney Thomas wrote:
> Can someone suggest an E-R tool that will read a _PG_ database and 
> create an E-R diagram - crows feet and all? Are there any that are 
> available for free?
> 
> Thanks
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
----------------------------------------------------------------------
Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/



view thread (5+ messages)  latest in thread

Message-ID: <20040607220520.GT23845@ontko.com>
Permalink:  ../20040607220520.GT23845@ontko.com/
Also on:    postgresql.org/message-id/20040607220520.GT23845@ontko.com

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: rayo@ontko.com, renneyt@yahoo.com
  Subject: Re: E-R Tool
  In-Reply-To: <20040607220520.GT23845@ontko.com>
  References: <20040531211523.46183.qmail@web14101.mail.yahoo.com> <40BC7107.2040703@trade-india.com> <40C164A6.80708@yahoo.com> <20040607220520.GT23845@ontko.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