PgAdmin autocompletion in other schemas
Can anyone advise me on how to make the autocomplete in PgAdmin not only work (properly) in the public schema? Let’s say I have a schema called sandbox and I’m lazy to constantly type the schema prefix in front of the object names. The solution to this is to use search_path (with appropriate grants of course), but it doesn’t seem to solve the autocomplete without schema prefix. Another problem is that when I use the schema prefix, the database objects appear in the autocomplete list (regardless of whether I have previously set search_path), but not when using table aliases (even though the public schema does autocomplete with aliases)! Does anyone know a solution to this? Thanks in advance for your tips!