Guillaume LELARGE <guillaume(dot)lelarge(at)gmail(dot)com> writes:
> I've made more tests on schemas. I'm able to drop information_schema and
> public schemas but I can't drop pg_catalog and pg_toast. It makes me think
> that only pg_* are system schemas and that public and information_schema are
> public schemas. Am I right on this one ?
Yeah, both of the latter are intentionally droppable because nothing in
the core server depends on them. The C code is explicitly aware of both
pg_catalog and pg_toast, so those are pinned.
regards, tom lane