On Tue, Dec 14, 2010 at 12:00 PM, Kenneth Gonsalves <[email protected]> wrote: > can anyone suggest a neat tool for a graphical view of a postgresql > database?
If you are looking for the equivalent (more or less) of Toad for Oracle / SQL Develoer for Oracle, then SquerrilSQL comes to mind (http://squirrel-sql.sourceforge.net/). You will have to download the Java Driver JAR file (JDBC Driver) from http://jdbc.postgresql.org/ and add it to the list of drivers before configuring your database. Ofcourse, you need java to be installed on your PC. <From your next email> >[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties >java.lang.ClassNotFoundException: org.postgresql.Driver > >Failed to load driver 'org.postgresql.Driver' >This entry doesn't point to a valid file/directory: >[/whereever/postgresql-8.0-312.jdbc3.jar] Download the JDBC JAR (Java Database driver JAR file from http://jdbc.postgresql.org/download.html. Add it to the class path like this: $export CLASSPATH=$CLASSPATH:<path to the jar file, including the .jar> HTH. with regards, Natarajan. _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
