Adriano A Costa

Generating postgresql database model with schemaSpy in windows

---

Make sure you have JAVA installed on your machine if you download it at https://www.java.com/en/download/ie_manual.jsp?locale=en_En, if you have not;

Go to the link http://www.graphviz.org/download/ to download the corresponding version of your Windows;

After the installation is complete, enter it in the environment variables:

Download the jar of schemaspy in http://schemaspy.org/;
Download the drive of postgres in https://jdbc.postgresql.org/download.html;

Preferably leave everything within it to facilitate organization and execution;

Open your command teminal, navigate to the folder where the files are and run the command below according to your configuration:

java -jar schemaspy-6.1.0.jar -t pgsql \
  -s public -db [db name] -u [db user] -p [password] \
  -host localhost -o /tmp \
  -dp /path/to/JDBC/driver/postgresql-42.2.12.jar

Fonte: https://gist.github.com/dpapathanasiou/c9c6236a410e9d018ae0