Re: schemas not appearing in pgAdmin

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.