Reverse engineer to get UML with PostgreSQL

Question

Are there any tools to use with Postgres so that I can create UML for the database that I already created.

Answer 1

There are some good products in Visual Paradigm, check out http://www.visual-paradigm.com/ Most of their products work with Linux, OS X, and Windows.

Answer 2

You can adapt this script for MySQL http://askuml.com/blog/list-all-fields-of-all-mysql-db-tables-in-yuml-class-diagrams/ just by changing the driver from Mysql to Postgress found here http://softinnov.org/rebol/pgsql.shtml

This is the reverse enginiering sample for Wordpress DB:

Answer 3

ppstgres_autodoc is a standard open source tool. http://www.rbt.ca/autodoc/

Answer 4

I used SQL Power Architect , which has a free version to do most of the tasks you need, using reverse engineering and the like. I found it easy to use and simple.