pgAdmin provides some basic functionality around autosuggestion and autocompletion but as you noticed, it's not as perfect as expected.
I don't think pgAdmin is going to be improved in this area. I suggest to check other solutions. Personally I can recommend SQL Assistant we use in our company (paid software). It's quite nice tool which hooks to other apps (pgAdmin, notepad+ and more) adding powerful features including autocompletion. Recently they provide simple SQL Editor (pgadmin like) based on SA core. SA supports not only postgresql but a lot of other DBMS. Unfortunately it's Windows only due to nature of its core: it hooks to app windows extending it's functionality.
Of course there are also stand alone apps, like EMS SQL Manager and more.
Speaking about checking functions during compilation, it's not fault of pgAdmin. it's postgresql feature (not welcomed though). Only functions written in SQL language can be fully checked during compilation while for plpgsql checking is limited. If you want to perform deeper verification of plpgsql functions you might be interested in plpgsql_check extension
with regards
On 21.11.2015 16:43, Manjeet Kumar wrote:
Dear Team,
We are using Postgre admin 111 version 1.20 with database server 9.3 enterprise edition for application development with a team size of 10 database developers.We are facing a high development efforts because of autosuggestion , semantic check and query formatting options are not available in PGADMIN 3 GUI tool i.e. once I write query like "Select t. from tablename t" then while using "t."its not providing me the columns available for that table so all times we need to write the whole column name manually and if name of the column have lengthy prefix then it is more time consuming.Even no developer could remember the name of all the columns in a tables so developer needs to search the table first in object browser and then check the name.
Additionally ,while compiling the procedure and packages semantic check is not being validated so any failure would be checked at run time at one level of testing only so increasing the development efforts heavily.
Please help to add these features ,it would be very helpful for all the postgre developer.If I need to send the same to any other group please share the group mail.
Regards,
Manjeet Kumar