when selecting the fieldname only 10 fields are being fetched.
i think limiting to 10 fields is ok, although scrolling would also be fine.
the fields should be ordered (ORDER BY 1)
if a letter is entered to the field, the query should be updated and a search for that letter(s) executed. SELECT DISTINCT myfield FROM "myschema"."mytable" WHERE myfield ~* '.*w.*' ORDER BY 1 LIMIT 10 (NOTE: or maybe myfield LIKE 'w%'?)
when selecting the fieldname only 10 fields are being fetched. i think limiting to 10 fields is ok, although scrolling would also be fine.
ORDER BY 1)SELECT DISTINCT myfield FROM "myschema"."mytable" WHERE myfield ~* '.*w.*' ORDER BY 1 LIMIT 10(NOTE: or maybemyfield LIKE 'w%'?)