Relative Content

Tag Archive for autocompletepgadmin

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!