Tools to generate database tables diagram with Postgresql

Question

Are there any free tools to generate tables diagrams with Postgresql

User · Answer

SchemaCrawler for PostgreSQL can generate database diagrams from the command line  with the help of GraphViz  You can use regular expressions to include and exclude tables and columns  It can also infer relationships between tables using common naming conventions  if not foreign keys are defined

User · Answer

Inside Eclipse I ve used the Clay plugin  ex Clay-Azurri   The free version allows to introspect   reverse engineer   an existing DB schema  via JDBC  and make a diagram of some selected tables

User · Answer

Check the wiki  http   wiki postgresql org wiki Community Guide to PostgreSQL GUI Tools

User · Answer

Quick solution I found was inside the pgAdmin program for windows   Under Tools menu there is a  Query Tool    Inside the Query Tool there is a Graphical Query Builder that can quickly show the database tables details   Good for a basic view

User · Answer

PostgreSQL Autodoc has worked well for me  It is a simple command line tool  From the web page      This is a utility which will run through PostgreSQL system tables and returns HTML  Dot  Dia and DocBook XML which describes the database

User · Answer

Just found http   www sqlpower ca page architect through the Postgres Community Guide mentioned by Frank Heikens   It can easily generate a diagram  and then lets you adjust the connectors

User · Answer

I love schemaspy for schema visualisations  Look at the sample output they provide  and drool  Note the tabs   You ll need to download the JDBC driver here  then your command should look something like   java -jar schemaspy-6 0 0-rc2 jar -t pgsql -db database name -host myhost -u username -p password -o   schemaspy -dp postgresql-9 3-1100 jdbc3 jar -s public -noads   Sometimes using options -port will not working if your database has diferrent port  so you have to add manual port after host parameter  for example   java -jar schemaspy-6 0 0-rc2 jar -t pgsql -db database name -host myhost myport -u username -p password -o   schemaspy -dp postgresql-9 3-1100 jdbc3 jar -s public -noads   You ll need to install graphviz as well if you want graphics  apt-get install graphviz for debian based distros

[postgresql] Tools to generate database tables diagram with Postgresql?

Examples related to postgresql

Examples related to diagram