Hi Don,
Don,
You can use the postgresql_qutodoc as follows:
Usage:
postgresql_autodoc.pl [options] [dbname [username]]
Options:
-d <dbname> Specify database name to connect to )
-f <file> Specify UML (dia) output file
-F <file> Specify index (HTML) output file
-h <host> Specify database server host
-p <port> Specify database server port
-u <username> Specify database username
--password=<pw> Specify database password
--no-index Do NOT generate HTML index
--no-uml Do NOT generate XML dia file
--no-docbook Do NOT generate DocBook SGML file(s)
--no-dot Do NOT generate directed graphs in the dot language
(GraphViz)
For example if your dbname=test, and username=user and password=pass you
can run the script like this (in the directory that you have the file on
it)
../postgresql_autodoc.pl -d test -u user --password='pass' -F test.dia
this will create the UML file test.dia in the same directory
to get more help on running the postgresql_autodoc.pl you can use
../postgresql_autodoc.pl --help
I hope it helps.
Rosta
>> Don,
>>
>> Try postgresql_autodoc-1.01.tar.gz I have been using it and it is
>> great.
>> It creates a dia file. Of course all the boxes/tables are on top of
>> one another and you manually have to organize the layout. The only
>> really problem is that the referencial integrety relationships are a
>> type of line that you can't insert a bend or curve into. But its is
>> still a really sharp tool.
>>
>> Phillip Allen
>
> ok thanx it looks great but I don't how to use perl script with pgsql
> (cause it's a *.pl file right?). could you tell me how to use it
> please?
>
> thanx in advance
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
************************************
Rosta Farzan
Laboratory for Adaptive Hypermedia and Assistive Technologies
Department of Math and Computer Science CSU Hayward
rosta@acc.csuhayward.edu
(510) 885-4026
*************************************