Skip to content

Instantly share code, notes, and snippets.

@arnaudbesnier

arnaudbesnier/schemaspy.sh

Last active April 26, 2019 13:48
Show Gist options
  • Save arnaudbesnier/02da2220f196f7ae01bf51a60b0a155c to your computer and use it in GitHub Desktop.
Save arnaudbesnier/02da2220f196f7ae01bf51a60b0a155c to your computer and use it in GitHub Desktop.
Download ZIP
SchemaSpy setup & usage
Raw
schemaspy.sh
brew install graphviz --with-librsvg --with-pango
# dowload https://github.com/schemaspy/schemaspy/releases/download/v6.0.0-rc1/schemaspy-6.0.0-rc1.jar
# download https://jdbc.postgresql.org/download.html
java -jar schemaspy-6.0.0-rc1.jar -t pgsql -db dbname -host localhost:5435 -u username -p ************ -o ./schemaspy -dp postgresql-9.4.1208.jre6.jar -s public -noads
@arnaudbesnier
Copy link
Author

To split the generated PNG:

brew install imagemagick
magick image.png -crop 2x2@ +repage splited%02d.png

@arnaudbesnier
Copy link
Author

arnaudbesnier commented Apr 26, 2019 •
edited

For forest local database:
java -jar schemaspy-6.0.0-rc1.jar -t pgsql -db forest -host localhost:5435 -u forest -p secret -o ./schemaspy -dp postgresql-42.2.1.jar -s public -noads

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment