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. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org