I installed Postgre today and I want to watch database shema.
I resolvse to use schemaSpy and download it and also schemaSpyGui
and then I see:
This is the command (password not displayed!) SchemaSpyGUI has generated:
java -jar "D:\free\schemaSpy_5.0.0.jar" -dp "D:\free\postgresql-9.1-903.jdbc4.jar" -t pgsql -db marc_db -host localhost -port 5432 -u marc -connprops "D:\free\schemaSpyGUI20090302\properties\pgsql.properties" -o "D:\free\schemaSpyGUI20090302\marc_marc_db_"
Failed to query Graphviz version information
with: dot -V
java.io.IOException: Cannot run program "dot": CreateProcess error=2, The system cannot find the file specified
Using database properties:
[D:\free\schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details...
No tables or views were found in schema 'marc'.
The schema does not exist in the database.
Make sure that you specify a valid schema with the -s option and that
the user specified (marc) can read from the schema.
Note that schema names are usually case sensitive.
3 schemas exist in this database.
Some of these "schemas" may be users or system schemas.
information_schema pg_catalog public
These schemas contain tables/views that user 'marc' can see:
information_schema pg_catalE=2og publicI=2
I have installed Graphviz2.38
And if from cmd I type
C:\Program Files (x86)\Graphviz2.38\bin>dot -V
dot - graphviz version 2.38.0 (20140413.2041)
Please help.
update
after advice in comment I added path\to\Graphviz2.38\bin to the Path environment variable and now I see following:
This is the command (password not displayed!) SchemaSpyGUI has generated:
java -jar "D:\freelance\db_things\schemaSpy_5.0.0.jar" -dp "C:\Users\redwhite\.m2\repository\postgresql\postgresql\9.0-801.jdbc4\postgresql-9.0-801.jdbc4.jar" -t pgsql -db marc_db -host localhost -port 5432 -u marc -connprops "D:\freelance\db_things\schemaSpyGUI20090302\properties\pgsql.properties" -o "D:\freelance\db_things\schemaSpyGUI20090302\marc_marc_db_"
Using database properties:
[D:\freelance\db_things\schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details...
No tables or views were found in schema 'marc'.
The schema does not exist in the database.
Make sure that you specify a valid schema with the -s option and that
the user specified (marc) can read from the schema.
Note that schema names are usually case sensitive.
4 schemas exist in this database.
Some of these "schemas" may be users or system schemas.
information_schema pg_catalog pg_toast_temp_1 public
These schemas contain tables/views that user 'marc' can see:
informationE=2_sch emapg_catalog publicI=2
my shema looks like this:
