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 Using database properties: [schemaSpy_3.1.1.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties java.lang.ClassNotFoundException: org.postgresql.Driver Failed to load driver 'org.postgresql.Driver' from: [] This entry doesn't point to a valid file/directory: [/whereever/postgresql-8.0-312.jdbc3.jar] Use -t [databaseType] to specify what drivers to use or modify one of the .properties from the jar, put it on your file system and point to it with -t [databasePropertiesFile]. For many people it's easiest to use the -cp option to directly specify where the database drivers exist (usually in a .jar or .zip/.Z). Note that the -cp option must be specified after schemaSpy_3.1.1.jar ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
