| From: | vladimir konrad <v(dot)konrad(at)lse(dot)ac(dot)uk> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Database reverse engineering |
| Date: | 2007-10-10 10:35:07 |
| Message-ID: | fei9sn$14ca$1@news.hub.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> I am trying to use postgresql-autodoc. The autodoc finds all the Perl
> modules and compiles but when I go to /usr/local/bin and run
> postgresql_autodoc like this
I had a good luck with schema-spy (done in java)...
http://schemaspy.sourceforge.net/
Vlad
ps: the command I use is (all on one line):
java -jar ~/app/schemaspy/schemaSpy_3.1.1.jar -t
pgsql -cp /usr/share/java/postgresql-8.2-506.jdbc3.jar -host localhost -db
database_name -s public -u database_user -o doc/db
-cp - the location of postgresql jdbc driver
-o - output directory
The database_user does not need password for localhost connection to
postgresql on my system...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2007-10-10 11:18:51 | Re: replacing single quotes |
| Previous Message | Richard Huxton | 2007-10-10 10:12:43 | Re: ORDER BY - problem with NULL values |