Autocompletion Queries used by `psql`

Search for ho:

SELECT pg_catalog.quote_ident(c.relname)
FROM pg_catalog.pg_class c
WHERE c.relkind IN ('r', 'S', 'v', 'm', 'f', 'p')
AND substring(pg_catalog.quote_ident(c.relname),1,2)='ho'
AND pg_catalog.pg_table_is_visible(c.oid)
AND c.relnamespace <> (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'pg_catalog')
UNION
SELECT pg_catalog.quote_ident(n.nspname) || '.'
FROM pg_catalog.pg_namespace n WHERE substring(pg_catalog.quote_ident(n.nspname) || '.',1,2)='ho'
AND (
  SELECT pg_catalog.count(*)
  FROM pg_catalog.pg_namespace
  WHERE substring(pg_catalog.quote_ident(nspname) || '.',1,2) = substring('ho',1,pg_catalog.length(pg_catalog.quote_ident(nspname))+1)) > 1
UNION
SELECT pg_catalog.quote_ident(n.nspname) || '.' || pg_catalog.quote_ident(c.relname)
FROM pg_catalog.pg_class c, pg_catalog.pg_namespace n
WHERE c.relnamespace = n.oid
AND c.relkind IN ('r', 'S', 'v', 'm', 'f', 'p')
AND substring(pg_catalog.quote_ident(n.nspname) || '.' || pg_catalog.quote_ident(c.relname),1,2)='ho'
AND substring(pg_catalog.quote_ident(n.nspname) || '.',1,2) = substring('ho',1,pg_catalog.length(pg_catalog.quote_ident(n.nspname))+1)
AND (
  SELECT pg_catalog.count(*)
  FROM pg_catalog.pg_namespace
  WHERE substring(pg_catalog.quote_ident(nspname) || '.',1,2) = substring('ho',1,pg_catalog.length(pg_catalog.quote_ident(nspname))+1)) = 1
LIMIT 1000