Data Dictionary generators for PostgreSQL to Confluence

[Matt S]

I'm looking for a tool that takes PostgreSQL tables and outputs a Data Dictionary in a wiki format (preferably Confluence). It seems like most tools out there require a lot of manual work/multiple tools to accomplish this task (IE> SchemaSpy, DB Visual Architect, Confluence plugins to take outputted HTML DD and convert to Confluence). I'm looking for ONE tool that will scan my Postgres tables and output a wiki friendly Data Dictionary that will allow seamless maintenance as the DB changes, without having to update my database and the DB schema in the other tool.

[JohnA]

You could use the SQL macro to show information about the database. Use the in-built PSQL commands to provide information about a table similar to http://wiki.postgresql.org/wiki/Retrieve_primary_key_columns (which didn't actually work for me).

Here at Atlassian, we document our databases in Confluence, but it's mostly manual. We do, however, include 'sample data' by using the SQL macro to show some sample rows of the database. This makes it easy for people to 'see' the data rather than having to scan the row definitions. For an example, see: http://confluence.atlassian.com/display/DISC/Confluence+Reporting+HOWTO+-+7a.+Example+-+Live+Data+Dictionary