Skip to main content

Transfer View Ownership



  • Alon Brody

    You are probably getting the syntax error because you did not use double-quotes. The following is the correct way to use this query:
    alter table "table/view" owner to "user";
    In general, in each query, I would suggest to enclose entities in double-quotes.

    Having said that, you will still get an error because only a superuser can perform a change of ownership. Our support team will be more than happy to help you with this change. All you need to do is email with the list of tables/views you wish to transfer ownership and the new owner email address.

  • mmorganfield

    Great, thanks Alon! That makes sense, I also noticed I could only see myself when looking at pg_users. I’ll consolidate and send.


Please sign in to leave a comment.

Powered by Zendesk