Re: [pgadmin-support] Re: PG admin 111 v 1.20 - autosuggestion , semantic check and query formatting Features

[Michal Kozusznik]

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


<<attachment: kozusznik_michal.vcf>>-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support