How to rename a table in Redshift

Below is the syntax to rename a table in Redshift database:

alter table tablename   
rename to new_tablename;
See also  How to Refresh a Materialized View in Redshift