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. (It was
still accessible using a schemaname.tablename notation and appeared to
work technically correct.)
Is there any way to rename a schema?
Jochem