I’m leaving my current role and have a replacement taking over our Panoply instance. In the past, I’ve noticed that when switching between users I’m unable to make changes to a view if I’m not the owner, so I’d like to make sure that they can make any changes to our views that are needed. Most likely my work email/Panoply username will be removed shortly after I leave.
I’ve tried the
ALTER TABLE view OWNER TO user, but I’m getting syntax errors with the @ in the username. I’ve tried escaping\ and quote_literal, inputing as a string, etc. but not getting past syntax errors. Are users able to transfer ownership of views, and if so, what’s the best way to accomplish that?