CSN wrote: > Is there a way to change the owner of a schema > (without deleting/recreating it)? No, I don't see a way to change the owner. You might be able to update the pg_namespace table to do this, but I am not sure. Of course, you can control the permissions on the schema easily with GRANT ON SCHEMA. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org