Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Using SchemaCrawler on PostgreSQL databases

Generate Schema Diagram (with SchemaCrawler)

See also: SchemaCrawler Database Diagramming.

  1. Downlod the latest release of SchemaCrawler, for example v14.16.01 was tested to work.

  2. Ensure Java is in place.

  3. Run:

    $ ./schemacrawler.sh \
        -server=postgresql \
        -host=localhost \
        -port=5432 \
        -database={…} \
        -schemas={…} \
        -user={…} \
        -password={…} \
        -infolevel=standard \
        -command=schema \
        -outputformat=png \
        -outputfile=graph.png
    
  4. See output: graph.png

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.