2016-12-29 1:03 GMT+01:00 Rich Shepard <rshep...@appl-ecosys.com>: > On Wed, 28 Dec 2016, Adrian Klaver wrote: > > An example from my machine that works: >> aklaver@tito:~/bin> java -jar schemaSpy_5.0.0.jar -t pgsql -s public -u >> postgres -db production -host localhost -dp >> /home/aklaver/bin/postgresql-9.4.1212.jre6.jar >> -o s_spy >> > > Adrian, > > That's interesting. I specified my username, not postgres, since that's > how I access the databases from the psql CLI. But, since I've resolved the > issue to my satisfaction and deleted the schemaSpy subdirectory I've no > incentive to try again. > > Time now to fill them thar tables with fake data so I can test as I > develop. > > Happy new year to you, > > Rich > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
Hi I d'like to tell about Sql Power Architect ( http://www.sqlpower.ca/page/architect), an open-source software. Well explained on the website but notice interessting feature such: - comparing 2 database structure, and generating stmts to harmonize differences in SQL or in liquibase ( http://www.liquibase.org/ ) - infers the implicit FK with names - multiplateform / multi database (absed on JDBC drivers) - generate giant pdf for giant models Thanks for the link to the CLI shemaSpy, a pity the export is in html and not reusable stuff like csv
