3 edited body; edited tags
source | link

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

Is there a way to accomplish that?

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?

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?

    Tweeted twitter.com/#!/StackDBAs/status/394035524748713984
2 edited tags
| link
1
source | link

PostgreSQL Change owner of all tables under a specific schema

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?