/schema

get a dot file from a postgres database schema

Primary LanguageShellMIT LicenseMIT

schema

generate erm like database schema from postgresql db

./schema.sh | dot -Tpng > schema.png
  • -u|--user database user (default: postgres)
  • -d|--database database name (default: postgres)
  • -s|--schema database schema (default: public)

requirements

  • PostgreSQL must be up and running
  • dot must be installed (see graphviz for further reading)

sample

When you take the generated tables from my database init scripts, you get

schema

as a result.

Contact

Jan Frederik Hake, jan_hake@gmx.de. @enter_haken on Twitter.