I found out today that it is a bad idea, at least as far as pgadmin is concerned, to rename the public schema. The query that pgadmin uses to list schemas checks if the oid is below a certain threshold and rejects the renamed public schema. Is that a bug or is it working as designed?
Jim
- [pgadmin-support] rename public schema Jim Cullison