On 02/03/2010 07:02 PM, Paul McNett wrote: > On 2/3/10 4:07 PM, Leland Jackson wrote: > >> that hold the email users. It kind of hard working with the dbmail >> database, because there a lots of table and the creator of the system >> has normalzed everything to the extreme, (eg an email is spread over >> many tables all normalized), so to see the entire email you need to join >> many tables together parent/child keys. >> > Sounds like a perfect opportunity for an admin app... > > Paul > > I'm using DBVisualizer, free edition, phpPgAdmin, and probably should download the latest version of pgadmin3, which I've used in the past, but none of those have a way to easily join tables together by dragging and dropping foreign keys into their primary keys to create the SQL query need to produce the desired result. There are a number of products that will do this, but most of them only run in windows, or have a scaled down version for the Linux OS, and are commercial.
Still, in order to use one of these drag and drop gui(s), I would really need to have a good knowledge of the database I'm working with; its tables, table fields, indexes, relations, etc, and DBmail installs with scripts that take care of everything for me. Also, the DBmail Administrator make the normal day to day operation of the email database a no brainer. I've been thinking about buying DBvisualizer, a java based application, that run in Linux. What's your opinion of DBvisualizer as a PostgreSQL Admin tool, and what is your favorite bui admin tool for working with PostgreSQL. Regards, LelandJ [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
