Thread: Re: Additional features for pgAdmin
Hi Aarjan,
From: A.j. Langereis [mailto:a.j.langereis@inter.nl.net]
Sent: 04 November 2004 22:04
To: Dave Page
Subject: Additional features for pgAdminDear Dave,For a few years I'm using postgresql now, but just resently I found out about pgAdmin (I did hear of it before, but never used it). Before, I alway's used the psql command-line tool for linux. I really like the pgAdmin tool and pitty it that I didn't try it before... It has great features for visualizing the database. But I'm still missing some features. I looked at your todo list, but they weren't there so I thought I'll mail them to you. Hopefully you like them as well and will add them in future versions.The features:* The visualization of the system tables and views (all pg_* tables), in psql this is shown with "\dS" command
You can view these already. switch on 'System Objects' on the 'Display' menu and then look in the pg_catalog schema for each database.
* The visualization of other/system schema's. From 7.4.0 there are several different schema's e.i. the information_schema. They can be listed in psql with the command "\dn"
'System Objects' will show these as well.
* Code-completion in the SQL tool in pgAdmin whould be very nice. Maybe similar to the psql tool by using Tab to complete things or maybe by using a popup-dropdownbox as it is used in (object oriented) programming languages.
Hmm, that's a good one. I'll add that to the todo. The editor control can already do drop-downs I believe so that shouldn't be beyond the realms of possibility.
* An other thing, but this might be a bug, I encounterd was that, if I tried to connect to a new but offline server, I first have to change a field in the properties window before I can click OK again. There is a good reason for disabling the OK button if no data was changed, but here the server was offline and all settings where OK. If for instance the address of the new server is missing I can understand that the OK button is disabled, the address is a vital thing for the connection.
Andreas; do you have a minute to look at that? (should have loads more time after next week - promise!! :-p ).
* Another nice feature would be the possibillity to change the languages. I'm Dutch, but when it comes to programming business I prefer english. Main reason for that is that most terms used are english.
Look under File -> Options to change the user language.
Hopefully you like these features as well and are able to add them the a future version.
Thanks for your feedback :-)
Regards, Dave
Dave Page wrote: > * An other thing, but this might be a bug, I encounterd was that, if > I tried to connect to a new but offline server, I first have to > change a field in the properties window before I can click OK again. > There is a good reason for disabling the OK button if no data was > changed, but here the server was offline and all settings where OK. > If for instance the address of the new server is missing I can > understand that the OK button is disabled, the address is a vital > thing for the connection. > > > Andreas; do you have a minute to look at that? Fixed. OTOH, we should discuss if we should register and connect at the same time at all, or simply remove automatic connection code. > (should have loads more time after next week - promise!! :-p ). Promises, promises... ;-) Regards, Andreas