How to rename the same column name in dozens of tables in Postgres?

Hi there,

I have dozens of tables where I need to rename one column in each of these. Is there any generic way to do that?

I am not really familiar with the scripting possibilities of Postgres.

Thanks a lot for your help!

Stefan