On 08/14/12 1:54 AM, Dario Beraldi wrote:
Hello,Apologies if this question has been asked before, but I couldn't come up with a decent solution...Can anyone advice about a tool to visualize a database schema? Ideally, I would like something that takes the SQL definition of a schema or database (essentially the output of pg_dump) and produces a graphical representation of the tables, constraints and indexes which can be moved around for ease of visualization (something like the "Graphical query builder" that comes with pgAdmin =>1.14). I don't care (and don't want) to modify or query the database with such tool, I just want to visualize it. (In fact, I tried to use pgAdmin for this but the graphical queries can only be saved as images and so they cannot be reloaded).
generically, thats known as ERD, Entity-Relationship-Diagram. there's ots of tools that do it, but I've never seen one that didnt make a rather messy graph of anything more complex than a few tables.
DBVisualizer is one such tool. Also, many UML tools can reverse engineer a database and generate graphics, and even let you modify the schema graphically.
the free tools I've seen have been pretty klunky and/or limited, the decent tools tend to be commercial and range from modest to rather expensive.
-- john r pierce N 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Programming PHP] [Kernel Newbies] [PHP Classes] [Find Someone Nice] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]