Re: Renaming schema's

Jochem van Dieten <jochemd@oli.tudelft.nl> writes:
> I have tried to rename a schema using:
> test=# update pg_catalog.pg_namespace
> test-#     set nspname = 'jochemd'
> test-#     where nspname = 'public';

> This didn't work out very well, the schema became invisible in
> pgAdminII, something I wouldn't want to do to our customers.

I would expect that to work; perhaps the problem is pgAdminII's?

            regards, tom lane