Toad Data Modeler from Quest Software is an E/R diagram tool that works for us.
And - it has a freeware version. Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporate Fax msteben <blocked::mailto:[EMAIL PROTECTED]> @autorevenue.com Visit our new website at <blocked::http://www.autorevenue.com/> www.autorevenue.com IMPORTANT: The information contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not the intended recipient (or the individual responsible for the delivery of this e-mail message to the intended recipient), please be advised that any re-use, dissemination, distribution or copying of this e-mail message is prohibited. If you have received this e-mail message in error, please reply to the sender that you have received this e-mail message in error and then delete it. Thank you. _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of sathiya psql Sent: Monday, March 17, 2008 3:58 AM To: pgsql-performance@postgresql.org Subject: [PERFORM] performance tools hi all, I want this mail to be continued about summary of performance tuning tools... or other postgres related tools.. I ll start with saying there is a tool SCHEMASPY ( i got to know about this from this group only ), this will draw ER diagram and gives interesting informations about our postgres database.. What are all the other opensource tools available like this for seeing informations about our postgres database... and tools for finetuning our postgres database.... Please join with me and summarize the names and usage of the tools.... Use SchemaSpy a very easily installable and usable tool...