Postgres Pro
Downloads
Home   >   mailing lists

Thread: pgsql/jdbc schema viewer needed

pgsql/jdbc schema viewer needed

From
"Matt Harrington"
Date:
I have a pgsql 7.0.3 database with JDBC installed.  I need to graphically
view the schema and would like to get ER diagrams or something useful like
that.  I've used pgaccess, but i need something that lets me see the
relationships between tables, etc.  something along the lines of Visio would
be great.  if it ran on windows, all the better.

i'm sure this is a FAQ, but i didn't see it in the FAQ list and the gizmo
for searching this lists archives seems to be broken.

i believe there is a free utility that does this for any JDBC database, but
I've been unable to find it with google.

thanks in advance,

---Matt

Re: pgsql/jdbc schema viewer needed

From
Matt Beauregard
Date:
On Wed, Dec 20, 2000 at 06:26:15PM -0800, Matt Harrington wrote:
>
> I have a pgsql 7.0.3 database with JDBC installed.  I need to graphically
> view the schema and would like to get ER diagrams or something useful like
> that.  I've used pgaccess, but i need something that lets me see the
> relationships between tables, etc.  something along the lines of Visio would
> be great.  if it ran on windows, all the better.

Somewhat related to this, I've been toying for a while with the idea
of hacking up something to turn pgsql schemas into ER diagrams
readable by GNU Dia.  Does anyone have pointers to an algorithm that
could be used to arrange entities and relationships on a page with a
minimum of crossed lines?


--
Matt Beauregard
Information Technology Operations, DesignScape

Ph: +61 2 9361 4233   Fx: +61 2 9361 4633

Re: pgsql/jdbc schema viewer needed

From
Alex Pilosov
Date:
> Somewhat related to this, I've been toying for a while with the idea
> of hacking up something to turn pgsql schemas into ER diagrams
> readable by GNU Dia.  Does anyone have pointers to an algorithm that
> could be used to arrange entities and relationships on a page with a
> minimum of crossed lines?
You should look at open-source CAD software, especially one that can do
"PCB layout". I remember I saw something like that, but I can't remember
the name. The problem you are solving is identical to chip layout problem
(maybe a bit simpler).

Re: pgsql/jdbc schema viewer needed

From
Patrick Welche
Date:
On Thu, Dec 21, 2000 at 04:02:49PM +1100, Matt Beauregard wrote:
...
> Does anyone have pointers to an algorithm that
> could be used to arrange entities and relationships on a page with a
> minimum of crossed lines?

AT&T came up with dot/neato http://www.research.att.com/sw/tools/graphviz/

Cheers,

Patrick