Re: Something I don't understand with the use of schemas

Guillaume LELARGE <guillaume.lelarge@gmail.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