khanhtran3005/install-schema-spy.md

Last active July 16, 2021 10:14

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/khanhtran3005/7794b3b06dcbd60ff8abe25ae4d37774.js"></script>
Save khanhtran3005/7794b3b06dcbd60ff8abe25ae4d37774 to your computer and use it in GitHub Desktop.

Download ZIP

Install and configure SchemaSpy to generate Postgres schema

Raw

install-schema-spy.md

MacOS: Mojave 10.14.12

Install Java SE: https://www.oracle.com/technetwork/java/javase/downloads/jdk11-downloads-5066655.html
Download SchemaSpy: http://schemaspy.org/
Download PostgreSQL JDBC driver: http://jdbc.postgresql.org/download.html
Install pango: brew install pango
Install Graphviz: brew install graphviz --with-pango

Run the following command to generate your schema:

java -jar path_to_schemaspy -s public -t pgsql -dp path_to_pgsql_driver -db db_name -host localhost -port 5432 -u root -p root -o path_to_output -gv /usr/local/Cellar/graphviz/2.40.1/ -renderer :cairo

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