See also: SchemaCrawler Database Diagramming.
-
Downlod the latest release of SchemaCrawler, for example v14.16.01 was tested to work.
-
Ensure Java is in place.
-
Run:
$ ./schemacrawler.sh \ -server=postgresql \ -host=localhost \ -port=5432 \ -database={…} \ -schemas={…} \ -user={…} \ -password={…} \ -infolevel=standard \ -command=schema \ -outputformat=png \ -outputfile=graph.png
-
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