Re: pg_dump not dumping some schemas

"Guo, Yun" <YGuo(at)cvent(dot)com> writes:
> It doesnt show up in custom format dump either I begin to wonder if its
> a bug in pg_dump.

pg_dump's handling of schemas is pretty darn simple; it's hard to see how
it could "miss" a schema like that. It would be useful to see the output
of these commands executed in the problematic database:

SELECT oid FROM pg_catalog.pg_namespace n
WHERE n.nspname ~ '^(test)$';
SELECT tableoid, oid, nspname, (SELECT rolname FROM pg_catalog.pg_roles
WHERE oid = nspowner) AS rolname, nspacl FROM pg_catalog.pg_namespace;

which are pretty much everything pg_dump issues that's directly related
to dumping schemas.

regards, tom lane