Menu
I'm looking for a FREE tool which allows to generate documentation for the DB schema, tables, column, keys, indices as a PDF or HTML format like the "Toad Data Modeler" which is a commecial tool.
I'm using Postgresql 9.2.
Could you suggest me some documentation generator?
Thanks
nico
458
You can store the data right in the row or you can use the large object facility. Since PostgreSQL now uses something called TOAST to move large fields out of the table there should be no performance penalty associated with storing large data in the row directly.
PostgreSQL is an advanced, enterprise class open source relational database that supports both SQL (relational) and JSON (non-relational) querying.
PostgreSQL uses a client-server model where the client and the server can reside on different hosts in a networked environment. The server program manages the database files, accepts connections to the database from client applications.
PostgreSQL is an advanced object-relational database management system that uses Structured Query Language (SQL) in addition to its own procedural language, PL/pgSQL. PostgreSQL is easy-to-use with a full stack of RDBMS database features and capabilities for handling data.
I've generally found SchemaSpy (git repo) useful for this purpose. It gets the job done with minimal pain and produces quite useful output. The cross-linked multi-page HTML output is particularly useful.
97
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
