rename all tables that have specific name postgresql code example

Example: rename table postgres

ALTER TABLE table_name
RENAME TO new_table_name;