how i can rename my database in postgresql code example

Example: rename table postgres

ALTER TABLE table_name
RENAME TO new_table_name;