When users RESTORE we set the ownership of the restored object to the user running the RESTORE. That user then has the option to move ownership later on, but they don't have a way to see who the original owner was. We have SHOW BACKUP...WITH PRIVILEGES but that doesn't include owner information.

The goal here is to either extend WITH PRIVILEGES to include ownership, have a separate option for seeing ownership or having ownership as a column we show by default. For API stability reasons, we might want to hide it behind a flag but I'm open to suggesting.

** Alternative **

• An option on RESTORE to restore with ownership retained. If there's a collision of ownership (e.g. user no longer exists) we should think through options. Options include ERROR, default to the user running restore, explicitly defined default, etc.