Re: Database reverse engineering - Mailing list pgsql-general

From Paul Boddie
Subject Re: Database reverse engineering
Date
Msg-id 1189978120.662629.65090@d55g2000hsg.googlegroups.com
Whole thread Raw
In response to Re: Database reverse engineering  (Ow Mun Heng <Ow.Mun.Heng@wdc.com>)
List pgsql-general
On 13 Sep, 06:12, Ow.Mun.H...@wdc.com (Ow Mun Heng) wrote:
> On Mon, 2007-09-10 at 13:00 -0600, RC Gobeille wrote:
> > Or this one:
> >http://schemaspy.sourceforge.net/
>
> Can't seem to get it to connect to PG using the example.
>
> java -jar schemaSpy_3.1.1.jar -t pgsql -u operator -p operator -o
> test_db  -host localhost -db test_db

As the end of the error message suggests, you might want to try
something like this:

java -jar schemaSpy_3.1.1.jar -cp postgresql-xxx.jar -t pgsql -u
operator -p operator -o test_db  -host localhost -db test_db

The argument for -cp needs to be the full path to the .jar file, and
must obviously use the real filename of that file itself. You may then
get complaints about not finding the schema: I had to specify "-s
public", I think.

Paul


pgsql-general by date:

Previous
From: Jeff Ross
Date:
Subject: Alter sequence restart with selected value...
Next
From: "Charles.Hou"
Date:
Subject: update command question?