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

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
>