NAME

       postgresql_autodoc - creates postgresql tables overview

SYNOPSIS

       postgresql_autodoc [options]

DESCRIPTION

       This  is  a utility which will run through PostgreSQL system tables and returns HTML, DOT,
       and 2 styles of XML which describes the database.

       The HTML is human readable (via webbrowser). The  first  style  of  XML  is  actually  the
       fileformat  of  Dia, a UML diagram tool. The second type of XML is similar to the HTML but
       in the Docbook 4 format. It enables yous to mix in other  docbook  documentation  via  the
       XREFs,  generating  PDFs, HTML, RTF, or other formatted documents. Between these tools and
       JavaDoc with the appropriate XREFs, documentation about a project can be generated quickly
       and be easily updatable yet have a very professional look with some DSSSL work.

OPTIONS

       -d <dbname>
              Specify database name to connect to (default: $database)

       -f <file>
              Specify output file prefix (default: $database)

       -h <host>
              Specify database server host (default: localhost)

       -p <port>
              Specify database server port (default: 5432)

       -u <username>
              Specify database username (default: $dbuser)

       --password=<pw>
              Specify database password (default: blank)

       -l <path>
              Path to the templates (default: /usr/share/postgresql-autodoc)

       -t <output>
              Type of output wanted (default: All in template library)

       -s <schema>
              Specify  a  specific  schema to match. Technically this is a regular expression but
              anything other than a specific name may have unusual results.

       --statistics
              In 7.4 and later, with the contrib  module  pgstattuple  installed  we  can  gather
              statistics  on  the  tables  in  the database (average size, free space, disk space
              used, dead tuple counts, etc.)  This is disk intensive on large  databases  as  all
              pages must be visited.

AUTHOR

       Rod Taylor <autodoc@rbt.ca>

                                            21/01/2005                      POSTGRESQL_AUTODOC(1)