Thanks, each of you for all the suggestions on schema generating tools. I haven't had a chance to evaluate them all yet but DBVisualizer looks pretty good. In the meanwhile I found SQL Power Architect, which is also free/open source, and can do this kind of diagraming but is not as good as DBVisualizer for my purposes. It has some other interesting features which would be of interest to someone working in an environment with several different kinds of databases. SchemaSpy looks to be a good option since the description mentions that they had to implement product-specific queries to support views but I haven't had a chance to try it out yet. Support for views is important to me and DBVisualizer and the other tools I have looked at so far, just display them as disconnected objects.

I was thinking of reporting back to this forum with advantages/disadvantages of each tool, as I see it, but realized that I was rapidly getting too far off topic for a list focused specifically on PostgreSQL.

-Aram

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 8 of 13 | next ›
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedNov 11, '10 at 5:01p
activeNov 15, '10 at 7:31p
posts13
users10
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase