John Ferlito wrote: >On Wed, Jul 03, 2002 at 12:27:56PM +1000, Bruce Badger wrote: > > >>John Ferlito wrote: >> >> >> >>> Has anyone come across a DB GUI for linux. What I'm after is one >>>of those visulisation type tools where you have all the tables with >>>lines joining the relationships etc. I found dbdesigner but it's in >>>alpha and doesn't import stuff. >>> >>> >>> >>> >>> >>> >>pgaccess for PostgreSQL is quite nice. >> >> > >It is use it all the time and is great for editing but I'm after one of >those tools that has a box for each table and links all the tables >together for the with regard to the relationships. I didn't think >pgacess could do this. > pgaccess can do this. Click "schema" and you can draw pretty diagrams of your database and export them to postscript if you want. It's been a really useful tool for me. Also, if you click "query", click "new" and then click "visual designer" you'll get a pointy-clicky query designer thing as well. I don't really use this myself so I can't comment on how good it is. A few quick clicks then verify that it works for simple 1:1 joins.
pgaccess is a great tool. Highly recommended. HTH James. -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
