Re: [ADMIN] Documenting a DB schema

MicroOlap (or MicrOlap) does a nice job of creating schema diagrams for postgres. I have had a little trouble with re-engineering databases that have had a lot of alterations, however. But their tech support is reasonable. Mary Michael Monnerie wrote: On Dienstag, 4. März 2008 Shahaf Abi

Re: [ADMIN] Documenting a DB schema

On Dienstag, 4. März 2008 Shahaf Abileah wrote: > create table table_with_comments(a int comment 'this is > column a...'); > (see http://dev.mysql.com/doc/refman/5.0/en/create-table.html) > However, Postgres doesn't support the "comment" keyword.  Is there an > alternative? This sounds nice at fir

[ADMIN] Documenting a DB schema

I'm looking for a systematic way to document the schema for the database behind our website (www.redfin.com ), so that the developers using this database have a better idea what all the tables and columns mean and what data to expect. Any recommendations? It would be g