Using SchemaCrawler on PostgreSQL databases

gistfile1.md

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

fix dashes

schemacrawler.sh --server=postgresql --host=localhost --port=5432 --database=database --schemas=public --user=userbd --password=passwd --info-level=standard --command=schema --output-format=png --output-file=graph.pn