As I wrote, SQL Workbench is good benchmark - it is not possible to select columns without named table, again, there is even possibility to filter list of available elements (tables, views, columns,...).
In my opinion GUI tool should support this feature (with or without psql background). This speeds up coding dramatically. Right now I have to copy/paste column names to avoid misspell.
Regards,
Bartek
2012/3/14 Dave Page
<dpage@pgadmin.org>... Once psql gains the ability to autocomplete SELECT column
names (which I believe is unlikely to happen, as without knowing the
table name, even a moderately sized database could end up listing
thousands of columns)
Totally agree