I use this script on an Ubuntu system: #!/bin/bash set -eu postgresql_autodoc -d example_dev -u example_dev -h localhost --password=xxxxxxxx dot -Tpng -o example-schema.png example_dev.dot dot -Tpdf -o example-schema.pdf example_dev.dot That gives you a schema diagram in pdf, png, dia, and dot format, including foreign keys. It also exports the table and column info as html and xml. I'm pretty sure you can install postgresql_autodoc with apt-get, but I don't recall for sure now. Good luck! Paul On Thu, Jan 16, 2014 at 1:09 PM, Bartosz Dmytrak <bdmytrak@xxxxxxxxx> wrote: > Hi, > > try DBVisualizer > > > > -- > > Regards, > > Bartek -- _________________________________ Pulchritudo splendor veritatis. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
