원본출처 : 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.
|