Re: Database reverse engineering

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: Raw Message | Whole Thread | 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...

In response to

Browse pgsql-general by date

  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