PostgreSQL – Change Owner of Tablespace

You can change the owner of a Tablespace as shown below in Postgres database where tablespace_name is the name of your tablespace and role_name is the role/user that should own the tablespace.

ALTER TABLESPACE tablespace_name OWNER to role_name;

See also  PostgreSQL - Switching between databases