원본출처 : http://www.zort.ca/postgresql/

이 autodoc 프로그램은 PostgreSQL 데이터베이스 를 불러 들여서 그 구조를 XML/HTML 파일로 변형시켜 준다. 그리하여 Dia (http://www.lysator.liu.se/~alla/dia/) 에서 읽을 수 있는 포맷으로 변형시켜 준다. (Dia v0.88.1 에서 테스트 되어졌다)

Details Exported to Dia XML

Primary Key

Foreign Keys relating tables

Column Type and Default Value

Constraints on a column (CHECK statements)

Can group tables into StereoTypes or classifications based on regular expression.

int4 &*& nextval() -> SERIAL conversion (saves space)

Details Exported to HTML Docs

Primary Key

Foreign Keys and links to other tables

Column type, Not Null status, and default value

Table and column description

Table and Column Constraints

Ability to group tables into StereoTypes based on regular expressions

int4 & nextval() -> SERIAL conversion (saves space)

Descriptions stored in using COMMENT ON for Tables and Columns

Details Exported to DocBook Docs

The bits of information exported are the same as the above HTML Doc style output but is done in DocBook 4.1 format complete with IDs for XREFing. Makes for some pretty slick development docs to have the cross referenced PDF that includes data structure.

ID style is <database-table-<table> where <database> is the name provided by command line (or default arguement) and the <table> is the table with all (_)'s converted to (-)'s. That is, table 'i_love_these' in database 'stuff' will get an ID of stuff-table-i-love-these.