WebFaction
Community site: login faq

For some reason, I need to rename the 'public' schema. This is the command I used.

ALTER SCHEMA public RENAME TO public_copy

I got this error:

must be owner of schema public

Is there a way that I can set my database user to be the owner of public schema?

asked 11 Feb '15, 06:57

linsheng
13114
accept rate: 0%


The postgresql instance is shared among all users and most administrative actions are prohibited to ensure the stability of the service.

Changing the name of the 'public' schema will probably affect some of ours and other user's scripts and apps.

You should be able to do that if you use a private instance.

permanent link

answered 11 Feb '15, 11:50

iliasr ♦♦
2.2k14
accept rate: 34%

edited 11 Feb '15, 11:50

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×109

question asked: 11 Feb '15, 06:57

question was seen: 10,505 times

last updated: 11 Feb '15, 11:50

                              
WEBFACTION
REACH US
SUPPORT
LEGAL
© COPYRIGHT 2003-2021 SWARMA LIMITED - WEBFACTION IS A SERVICE OF SWARMA LIMITED
REGISTERED IN ENGLAND AND WALES 5729350 - VAT REGISTRATION NUMBER 877397162
5TH FLOOR, THE OLD VINYL FACTORY, HAYES, UB3 1HA, UNITED KINGDOM