I am trying to change the owner of all tables under the same schema in one command line. i.e: alter table schema_name.* owner to newowner

Is there a way to accomplish that?