[PATCH] Improve autocompletion for SELECT statements

A big part of my job is creating simple select statements with a few joins in them. Unfortunately, the existing autocomplete functionality of pgadmin was a bit too limited for my use case. A relatively simple query like: select * from person p join company c on p.company_id = c.id where p.name = 'John'  would be enough to completely throw the autocompletion off.

So I started working on a patch to improve the autocompletion a bit and the result is attached. It doesn't have all the features I would like it to have (no support for table aliases, for example) but it is already a big improvement for my use case.

Please comment if I need to change anything to get this patch into pgadmin.

This patch is against pgadmin3-1.14.0.tar.gz

Regards,

Wander Winkelhorst.