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.
