Is it possible to automatically generate a data model of an existing postgresql database?
-
I have an existing database with about 10 schemas and hundreds of tables total. It has been designed over the years by single person, who unfortunately saw so the need to document the structure. The database does contain foreign keys and comments, so it should be possible to export a data model to svg / visio using those. Has anyone ever done this before?
-
Answer:
Try PGMaestro
Daniel Entin at Quora Visit the source
Other answers
Look like you need data modeling tool. Check: http://stackoverflow.com/questions/2927895/a-good-database-modeling-tool-for-postgresql http://code.google.com/p/wwwsqldesigner/
Ron Warshawsky
I found the answer I was looking for: schemaSpy. great little Java app that reverse engineers a database and spits out HTML. Can be scripted and run from the command line, which is a big bonus
Joseph Beeson
Related Q & A:
- What is the best way to distribute an audio/video feed from a computer to TVs over existing indoor coax cable?Best solution by Audio-Video Production
- What is the best data model and database systems to store social graph?Best solution by Quora
- How to modify a schema.xml of an existing list?Best solution by SharePoint
- Is it possible to crawl through a database?Best solution by quora.com
- What are some phones for Verizon Wireless without a data plan or with a cheap data plan?Best solution by Yahoo! Answers
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.