How to add a column to all tables in the oracle / postgresql database

Hello, I've been searching and I did not find anything about it, I'd like to know if there's a way to add a column generically to the database, the database I work with has a tb_<nome_tabela> in the tables that I need this generic column, I thought about doing a procedure but I have no idea how I would do it, thanks.