Re: schemas not appearing in pgAdmin

[Dave Page <dpage(at)postgresql(dot)org>]

Derek Fonda wrote:
> I'm running postgres 8.0.3 (Solaris) and PgAdmin III 1.8.0
> 
> I created a schema in my prod DB that is named pgmacdon, however it
> appears that pgAdmin III is not displaying this schema as existing in
> the prod DB.
> 
> It would appear that you are using the wrong query to exclude the pg_*
> internal schemas
> 
> PgAdmin III appears to be doing a query similar to the following to
> retrieve the list of schemas to display:
> 
> SELECT
>  nspname,
>  CASE WHEN nspname LIKE 'pg\_tmp\_%%' THEN 1
>       WHEN (nspname LIKE 'pg\_%') THEN 0
>       ELSE 3 END AS nsptyp
> FROM
>  pg_namespace

Thanks - it was escaped, but because it was in a C string in the source
code it should have been double-escaped. Fixed in SVN for 1.8.

Regards, Dave.