On Thu, 2024-11-21 at 20:42 +0000, Benjamin Patrick wrote:
> I am using PGAdmin 4.8.8. New to the group and hoping this the correct group for assistance.
> My instance is an AWS instance so there isn't a viable superuser.
> I had a user create table with the table owner being themself. user.schema.tablename
> I wanted to change the owner to the dbowner, but was unable in pgadmin or script. dbowner.schema.tablename
See the documentation: https://www.postgresql.org/docs/current/sql-altertable.html
"To alter the owner, you must be able to SET ROLE to the new owning role,
and that role must have CREATE privilege on the table's schema."
Yours,
Laurenz Albe
