|
MySQL has MySQL Workbench for designing and documenting your schema, and generates CREATE and ALTER scripts based on your design. We're looking at migrating to PostgreSQL in the near future, and we do need a practical way of documenting and modifying the schema structure. What similar tools exist for Postgres (that are OS X/Linux compatible)? Alternatively, what equivalent conventions would be followed for designing and documenting the structure of your Postgres database? |
|||
|
Questions on Programmers Stack Exchange are expected to relate to software development within the scope defined in the FAQ. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about closed questions here.
|
I like generating documentation using tools such as SchemaSpy, which generates stuff like http://schemaspy.sourceforge.net/sample/ I'm not a fan of graphical ERD tools; pen and paper work sufficiently well for me. I use yEd for generating graphs occasionally, but it doesn't generate SQL (although how much work is that anyway?). Maintaining the schema, I like having SQL files which can recreate the schema from scratch. I write |
|||
|
|
